RE220 Lecture : Lecture
Get access
Related Documents
Related Questions
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? | ||||||||
|
PROBLEM 1: Analyze the following data using LINEAR TRENDANALYSIS. How many cars will be sold in time period 13?
TIME PERIOD | NUMBER OF CARS SOLD |
1 | 70 |
2 | 80 |
3 | 66 |
4 | 74 |
5 | 64 |
6 | 76 |
7 | 72 |
8 | 83 |
9 | 82 |
10 | 76 |
11 | 84 |
12 | 80 |
PROBLEM 2: A sample of 20 cars was taken, and the miles pergallon (MPG), horsepower, and total weight were recorded.
Develop a simple regression model to predict the dependentvariable, MPG, using horsepoweras the independent variable.
Develop a simple regression model to predict the dependentvariable, MPG, using weight asthe independent variable.
Using R², which of the 2 causal forecasting models, A or B, isbetter?
Develop a multiple regression model to predict the dependentvariable, MPG, using horsepowerand weight as the 2 independent variables.
Using R², how does the multiple regression model compare witheach of the 2 simple regression models?
MPG (Y) | HORSEPOWER (X1) | WEIGHT (X2) |
44 | 67 | 1844 |
44 | 50 | 1998 |
40 | 62 | 1752 |
37 | 69 | 1980 |
37 | 66 | 1797 |
34 | 63 | 2199 |
35 | 90 | 2404 |
32 | 99 | 2611 |
30 | 63 | 3236 |
28 | 91 | 2606 |
26 | 94 | 2580 |
26 | 88 | 2507 |
25 | 124 | 2922 |
22 | 97 | 2434 |
20 | 114 | 3248 |
21 | 102 | 2812 |
18 | 114 | 3382 |
18 | 142 | 3197 |
16 | 153 | 4380 |
16 | 139 | 4036 |
give answer to the problem 1 and 2 in excel.
I need these ratios:
Return on Assets
|