HREQ 1930 Lecture : HREQ 1930- Lecture 2
Get access
Related Documents
Related Questions
Supermarket scanner data of prices and quantities for various types of beef and poultry are available in the accompanying Excel file. The monthly data from the Economic Research Center of the US Department of Agriculture in cooperation with the Livestock Marketing Information Center (LMIC) covers January 2001 to July 2005. The file includes quantity and price data for three cuts of beef (Chuck Roast, Porter House and Ribeye) plus data for chicken prices and disposable income. a. Using regression analysis, estimate the demand functions for Chuck Roast, Porter House, and Ribeye. Indicate significance of each coefficient and of each model citing the relevant test statistics. b. Estimate the own price elasticity, cross elasticity, and income elasticity for each cut of beef.
Year | Month | ChuckQ | CkuckP | PHQ | PHP | RibEQ | RibEP | ChickP | DispInc | ||||||
2001 | 1 | 120 | $2.28 | 53 | $6.04 | 74 | $7.02 | $1.61 | 8664.6 | ChuckQ | Qty of Ground Chuck | ||||
2001 | 2 | 76 | $2.61 | 81 | $5.37 | 79 | $7.16 | $1.68 | 8689.8 | CkuckP | Price of Ground Chuck | ||||
2001 | 3 | 102 | $2.12 | 60 | $5.74 | 71 | $7.33 | $1.57 | 8711.7 | PHQ | Qty of Porterhouse | ||||
2001 | 4 | 106 | $2.41 | 65 | $6.93 | 112 | $7.38 | $1.73 | 8710.7 | PHP | Price of Porterhouse | ||||
2001 | 5 | 87 | $2.39 | 92 | $5.95 | 113 | $6.47 | $1.74 | 8716.5 | RibEQ | Qty of Ribeye | ||||
2001 | 6 | 94 | $2.11 | 157 | $5.24 | 89 | $7.14 | $1.63 | 8732.4 | RibEP | Price of Ribeye | ||||
2001 | 7 | 97 | $2.66 | 149 | $5.39 | 146 | $7.02 | $1.69 | 8733.2 | ChickP | Chicken Prices | ||||
2001 | 8 | 79 | $2.50 | 133 | $5.54 | 120 | $6.28 | $1.71 | 8727.7 | DispInc | Consumer Disposable Income | ||||
2001 | 9 | 138 | $2.39 | 97 | $6.28 | 120 | $7.57 | $1.79 | 8738.5 | ||||||
2001 | 10 | 129 | $2.30 | 113 | $5.43 | 106 | $6.72 | $1.65 | 8743.1 | ||||||
2001 | 11 | 77 | $2.69 | 78 | $5.46 | 76 | $7.73 | $1.75 | 8751.7 | ||||||
2001 | 12 | 94 | $2.44 | 123 | $4.81 | 93 | $7.71 | $1.79 | 8769.6 | ||||||
2002 | 1 | 135 | $2.23 | 87 | $5.49 | 83 | $6.74 | $1.65 | 8789.9 | ||||||
2002 | 2 | 120 | $2.45 | 73 | $5.54 | 136 | $6.87 | $1.72 | 8814.2 | ||||||
2002 | 3 | 131 | $2.24 | 88 | $5.76 | 119 | $7.11 | $1.68 | 8840.2 | ||||||
2002 | 4 | 104 | $2.41 | 108 | $5.28 | 114 | $7.00 | $1.67 | 8879 | ||||||
2002 | 5 | 144 | $2.24 | 82 | $6.05 | 151 | $6.70 | $1.63 | 8889.3 | ||||||
2002 | 6 | 139 | $2.08 | 148 | $5.34 | 248 | $7.08 | $1.66 | 8907.6 | ||||||
2002 | 7 | 98 | $2.42 | 155 | $5.10 | 201 | $6.54 | $1.73 | 8894.8 | ||||||
2002 | 8 | 112 | $2.47 | 45 | $6.88 | 168 | $6.46 | $1.73 | 8892.7 | ||||||
2002 | 9 | 184 | $2.34 | 97 | $5.67 | 165 | $6.72 | $1.76 | 8898.8 | ||||||
2002 | 10 | 98 | $2.33 | 82 | $5.65 | 105 | $6.89 | $1.68 | 8910.3 | ||||||
2002 | 11 | 109 | $2.35 | 65 | $6.38 | 88 | $7.69 | $1.62 | 8920.8 | ||||||
2002 | 12 | 135 | $2.35 | 53 | $6.22 | 108 | $7.44 | $1.83 | 8945.3 | ||||||
2003 | 1 | 132 | $2.22 | 63 | $5.86 | 182 | $6.65 | $1.70 | 8976.3 | ||||||
2003 | 2 | 142 | $2.38 | 59 | $6.72 | 150 | $6.72 | $1.67 | 9011.5 | ||||||
2003 | 3 | 128 | $2.45 | 55 | $7.12 | 144 | $7.51 | $1.68 | 9053.2 | ||||||
2003 | 4 | 94 | $2.53 | 49 | $6.54 | 121 | $7.80 | $1.84 | 9067.9 | ||||||
2003 | 5 | 93 | $2.34 | 92 | $6.70 | 161 | $7.40 | $1.81 | 9124.5 | ||||||
2003 | 6 | 126 | $2.48 | 88 | $6.91 | 280 | $6.64 | $1.74 | 9163.4 | ||||||
2003 | 7 | 83 | $2.40 | 65 | $7.33 | 170 | $6.68 | $1.71 | 9188.2 | ||||||
2003 | 8 | 109 | $2.54 | 92 | $6.70 | 165 | $7.73 | $1.82 | 9214.2 | ||||||
2003 | 9 | 112 | $2.46 | 41 | $7.75 | 106 | $8.20 | $1.80 | 9243.7 | ||||||
2003 | 10 | 83 | $2.86 | 42 | $7.22 | 104 | $8.32 | $1.80 | 9271.7 | ||||||
2003 | 11 | 90 | $2.90 | 56 | $7.57 | 91 | $9.74 | $1.79 | 9339.4 | ||||||
2003 | 12 | 77 | $3.03 | 30 | $8.40 | 63 | $9.87 | $1.85 | 9374.8 | ||||||
2004 | 1 | 86 | $2.83 | 41 | $6.65 | 67 | $9.92 | $1.61 | 9435.9 | ||||||
2004 | 2 | 165 | $2.55 | 51 | $6.94 | 111 | $8.48 | $1.61 | 9487.9 | ||||||
2004 | 3 | 109 | $2.25 | 25 | $7.40 | 118 | $7.51 | $1.64 | 9530.7 | ||||||
2004 | 4 | 89 | $2.37 | 34 | $7.45 | 107 | $8.27 | $1.66 | 9571.8 | ||||||
2004 | 5 | 125 | $2.27 | 54 | $7.51 | 125 | $8.27 | $1.66 | 9628.3 | ||||||
2004 | 6 | 108 | $2.28 | 33 | $8.60 | 117 | $8.86 | $1.66 | 9642.8 | ||||||
2004 | 7 | 88 | $2.52 | 34 | $8.54 | 119 | $8.55 | $1.70 | 9689 | ||||||
2004 | 8 | 101 | $2.64 | 41 | $8.36 | 143 | $8.87 | $1.85 | 9739.8 | ||||||
2004 | 9 | 85 | $2.64 | 51 | $6.98 | 100 | $7.48 | $1.72 | 9759 | ||||||
2004 | 10 | 113 | $2.61 | 45 | $6.88 | 82 | $8.20 | $1.63 | 9858.4 | ||||||
2004 | 11 | 85 | $2.69 | 27 | $7.19 | 73 | $8.59 | $1.68 | 9924.9 | ||||||
2004 | 12 | 90 | $2.67 | 31 | $7.08 | 70 | $8.10 | $1.64 | 10291 | ||||||
2005 | 1 | 113 | $2.62 | 38 | $6.89 | 89 | $8.34 | $1.59 | 10025.2 | ||||||
2005 | 2 | 98 | $2.70 | 39 | $7.05 | 84 | $7.90 | $1.55 | 10072.9 | ||||||
2005 | 3 | 86 | $2.82 | 30 | $7.80 | 105 | $7.88 | $1.61 | 10122 | ||||||
2005 | 4 | 93 | $2.66 | 38 | $7.88 | 111 | $8.92 | $1.64 | 10145.1 | ||||||
2005 | 5 | 127 | $2.51 | 55 | $7.68 | 159 | $7.60 | $1.60 | 10180.6 | ||||||
2005 | 6 | 83 | $2.47 | 40 | $8.17 | 141 | $7.99 | $1.65 | 10231.5 | ||||||
2005 | 7 | 94 | $2.44 | 39 | $8.06 | 156 | $7.18 | $1.62 | 10268.8 | ||||||
Problem 10-23A Make or Buy Decision [LO10-3]
Silven Industries, which manufactures and sells a highlysuccessful line of summer lotions and insect repellents, hasdecided to diversify in order to stabilize sales throughout theyear. A natural area for the company to consider is the productionof winter lotions and creams to prevent dry and chapped skin. |
Afterconsiderable research, a winter products line has been developed.However, Silvenâs president has decided to introduce only one ofthe new products for this coming winter. If the product is asuccess, further expansion in future years will be initiated. |
Theproduct selected (called Chap-Off) is a lip balm that will be soldin a lipstick-type tube. The product will be sold to wholesalers inboxes of 12 tubes for $8.50 per box. Because of excess capacity, noadditional fixed manufacturing overhead costs will be incurred toproduce the product. However, a $110,000 charge for fixedmanufacturing overhead will be absorbed by the product under thecompanyâs absorption costing system. |
Using theestimated sales and production of 100,000 boxes of Chap-Off, theAccounting Department has developed the following cost per box: |
Directmaterials | $ | 4.80 | |
Direct labor | 1.00 | ||
Manufacturingoverhead | 1.40 | ||
Total cost | $ | 7.20 | |
The costs above include costs for producing both the lip balmand the tube that contains it. As an alternative to making thetubes, Silven has approached a supplier to discuss the possibilityof purchasing the tubes for Chap-Off. The purchase price of theempty tubes from the supplier would be $1.20 per box of 12 tubes.If Silven Industries accepts the purchase proposal, direct laborand variable manufacturing overhead costs per box of Chap-Off wouldbe reduced by 10% and direct materials costs would be reduced by20%. |
Required: | |
1a. | Calculate the total variable cost of producing one box ofChap-Off. (Do not round intermediate calculations. Roundyour answer to 2 decimal places.) |
}uetr":ederswAnis,"""":ontiipcres_dab"t},:{2"_6,"0]:[7"_6,"llnu":51"_l,ul:n6"_2,"{}":32"_e,lsfa":etabphAlowShis,"seal:f2"_4,"-1":50"_1,:-4"_2,"-1":31"_0,":_5,":04""_e,lsfa":48"_},:{7"_3,"}]69:37"_7,"59":34"_[{":23"_e,ru:t5"_4,"1"leit%20Tew"N":mena,"}]seal:f7"_4,":14"_5,"[]":33"_},4"11:"2""c",88:"1""c",25"1":c0{"":19"_},3""2":"0:{9"_5,"]]}}%3B"px23:%20htighe:"8""_},N"IOSTUE"Q":76"_:{5"_5,"}}""":79"_",ox%20ber"p":75"_:{0"_3{"":_2{"":20"_,{}}%3B"px23:%20htighe:"8""_",seonsprer%20beumeNylst:"7""_},t"ghri:"8"_6,"uetr":43"_",ONTILUSO:"6"_7{"":55"_},"}"%24":81"_2,":53"_2,":21"_e,ru:t3"_6{"":55"_",CYENRRCU:"3"_7{"":29"_},"}:"9"_7,"~"7)(1~a:"5"_7{"":56"_},""":79"_",:"5"_7{"":30"_:{2""_:{0"_2{"},"}x%3B3p%202t:ghei%20h5%3Bde9a%237:%20orol-cndougrckba:"8""_},5"de9a%237:"9""_",ONTIESQU:"6"_7{"":55"_},"}:"9"_7,"t"os%20cleabrival%20taTo:"5"_7{"":30"_:{2""_:{0"_2{"[[":13"_e,lsfa":41"_},n"owpDro"d":27"_1,:-5"_2,"{}":75"_e,lsfa":82"_:{8"_2,"""":22"_e,lsfa":35"_e,ru:t6"_3,"{}":55"_",leab%20TedtltiUn:"9"_6,":37"_1,":18"_5{":[5"_6{" |
1b. | Assume that the tubes for the Chap-Off are purchased from theoutside supplier, calculate the total variable cost of producingone box of Chap-Off. (Do not round intermediatecalculations. Round your answer to 2 decimal places.) |
e}ru:td"rewenssA"i",:"n"ioptriscdeb_ta,"{}":62"_],[0":67"_l,ul:n1"_5,"llnu":26"_},:{2"_3,"seal:ft"behalpwAhosS"ie,lsfa":42"_1,:-0"_5,"-1":24"_1,:-1"_3,":05""_0,":_4,"seal:f8"_4,"{}":37"_],8}31":77"_9,:54"_3{":[3"_2,"uetr":45"_",e1tlTiw%20Ne:"e"am"n],e}lsfa":47"_1,":54"_],:[3"_3,""}63:"2""c",88:"1""c",25"1":c0{"":19"_},3""2":"0:{9"_5,"]]}}"}ONTIESQU:"6"_7{"":55"_},"}:"9"_7,"x"bor%20pe:"5"_7{"":30"_:{2""_:{0"_2{"},"}seonsprer%20beumeNylst:"7""_},t"ghri:"8"_6,"uetr":43"_",ONTILUSO:"6"_7{"":55"_},"}"%24":81"_2,":53"_2,":21"_e,ru:t3"_6{"":55"_",CYENRRCU:"3"_7{"":29"_},"}:"9"_7,"~"5)(2~a:"5"_7{"":56"_},""":79"_",:"5"_7{"":30"_:{2""_:{0"_2{"},"}5%3Bde9a%237:%20orol-cndougrckba:"8""_},5"de9a%237:"9""_",ONTIESQU:"6"_7{"":55"_},"}:"9"_7,"t"os%20cleabrival%20taTo:"5"_7{"":30"_:{2""_:{0"_2{"[[":13"_e,lsfa":41"_},n"owpDro"d":27"_1,:-5"_2,"{}":75"_e,lsfa":82"_:{8"_2,"""":22"_e,lsfa":35"_e,ru:t6"_3,"{}":55"_",leab%20TedtltiUn:"9"_6,":37"_1,":18"_5{":[5"_6{" |
1c. | Should Silven Industries make orbuy the tubes? | ||||
|
2. | What would be the maximum purchase price acceptable to SilvenIndustries? (Do not round intermediate calculations. Roundyour answer to 2 decimal places.) |
}uetr":ederswAnis,"""":ontiipcres_dab"t},:{2"_6,"0]:[7"_6,"llnu":51"_l,ul:n6"_2,"{}":32"_e,lsfa":etabphAlowShis,"seal:f2"_4,"-1":50"_1,:-4"_2,"-1":31"_0,":_5,":04""_e,lsfa":48"_},:{7"_3,"}]09:47"_7,"59":34"_[{":23"_e,ru:t5"_4,"1"leit%20Tew"N":mena,"}]seal:f7"_4,":14"_5,"[]":33"_},4"11:"2""c",88:"1""c",65"1":c0{"":19"_},3""2":"0:{9"_5,"]]}}"}ONTIESQU:"6"_7{"":55"_},"}:"9"_7,"s"betuf%20%20oox%20ber"p":75"_:{0"_3{"":_2{"":20"_,{}}e"nspoes%20rermbNulety"s":_7,""}htig"r":68"_e,ru:t3"_4,"N"IOUTOL"S":76"_:{5"_5,"}}%24":"1"_8,":23"_5,":21"_2,"uetr":63"_:{5"_5,"Y"NCREUR"C":73"_:{9"_2,"}}""":79"_",)~30a("~":75"_:{6"_5,""}:"9"_7,"""":75"_:{0"_3{"":_2{"":20"_,{}}%3B"e5ad79%20%23r:locod-unrokgac"b":_8,""}e5ad79"%23":_9,"N"IOSTUE"Q":76"_:{5"_5,"}}""":79"_",ceri%20pseharcpum%20muxima:"5"_7{"":30"_:{2""_:{0"_2{"[[":13"_e,lsfa":41"_},n"owpDro"d":27"_1,:-5"_2,"{}":75"_e,lsfa":82"_:{8"_2,"""":22"_e,lsfa":35"_e,ru:t6"_3,"{}":55"_",leab%20TedtltiUn:"9"_6,":37"_1,":18"_5{":[5"_6{" |
3. | Instead of sales of 100,000 boxes, revised estimates show asales volume of 115,000 boxes. At this new volume, additionalequipment must be acquired to manufacture the tubes at an annualrental of $32,000. Assume that the outside supplier will not acceptan order for less than 115,000 boxes. |
a. | Calculate the total relevant cost of making 115,000 boxes andtotal relevant cost of buying 115,000 boxes. (Do not roundintermediate calculations.) |
e}ru:td"rewenssA"i",:"n"ioptriscdeb_ta,"{}":62"_],[0":67"_l,ul:n1"_5,"llnu":26"_},:{2"_3,"seal:ft"behalpwAhosS"ie,lsfa":42"_1,:-0"_5,"-1":24"_1,:-1"_3,":05""_0,":_4,"seal:f8"_4,"{}":37"_],7}30":77"_2,:84"_3{":[3"_2,"uetr":45"_",e1tlTiw%20Ne:"e"am"n],e}lsfa":47"_2,":54"_],:[3"_3,""}89:"2""c",89:"1""c",87:"0""c:{9"_1,""}23:"1","3""2":"0:{9"_5,"]]}}e"nspoes%20rermbNulety"s":_7,""}htig"r":68"_e,ru:t3"_4,"N"IOUTOL"S":76"_:{5"_5,"}}%24":"1"_8,":23"_5,"uetr":63"_:{5"_5,"Y"NCREUR"C":73"_:{9"_2,"}}""":79"_",)~39a("~":75"_:{6"_5,""}:"9"_7,"""":75"_:{0"_3{"":_2{"":20"_,{}}e"nspoes%20rermbNulety"s":_7,""}htig"r":68"_e,ru:t3"_4,"N"IOUTOL"S":76"_:{5"_5,"}}%24":"1"_8,":23"_5,"uetr":63"_:{5"_5,"Y"NCREUR"C":73"_:{9"_2,"}}""":79"_",)~38a("~":75"_:{6"_5,""}:"9"_7,"""":75"_:{0"_3{"":_2{"":20"_,{}}"}ONTIESQU:"6"_7{"":55"_},"}:"9"_7,"t"os%20calot"T":75"_:{0"_3{"":_2{"":20"_[{],}}%3B"e5ad79%20%23r:locod-unrokgac%20bx%3B0p:%20ntdeint-ex"t":_8,"d"oleBylstr%20teeneCylst:"7""_},5"de9a%237:"9""_e,ru:t0"_1,"r"teen"c":68"_",ONTIESQU:"6"_7{"":55"_},"}:"9"_7,"g"inuy"B":75"_:{0"_3{"":_2{"":20"_,{}}%3B"e5ad79%20%23r:locod-unrokgac%20bx%3B0p:%20ntdeint-ex"t":_8,"d"oleBylstr%20teeneCylst:"7""_},5"de9a%237:"9""_e,ru:t0"_1,"r"teen"c":68"_",ONTIESQU:"6"_7{"":55"_},"}:"9"_7,"g"inak"M":75"_:{0"_3{"":_2{"":20"_,{}}%3B"e5ad79%20%23r:locod-unrokgac"b":_8,""}e5ad79"%23":_9,"N"IOSTUE"Q":76"_:{5"_5,"}}""":79"_",:"5"_7{"":30"_:{2""_:{0"_2{"[[":13"_e,lsfa":41"_},n"owpDro"d":27"_1,:-5"_2,"{}":75"_e,lsfa":82"_:{8"_2,"""":22"_e,lsfa":35"_e,ru:t6"_3,"{}":55"_",leab%20TedtltiUn:"9"_6,":37"_1,":28"_5{":[5"_6{" |
b. | Based on the above calculations,should Silven Industries make or buy the boxes? | ||||
|
4. | Refer to the data in (3) above. Assume that the outside supplierwill accept an order of any size for the tubes at $1.20 per box.Which of these is the best alternative? | ||||||||
|