Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need help answer 1-5 answeredIf you could provide steps on how to create the excel that would help me with future problems, but is not

Need help answer 1-5 answeredIf you could provide steps on how to create the excel that would help me with future problems, but is not necessary. Thanks!

image text in transcribed
Coffee Co. produces three products: coffee beans, tea bags, and chai. The following monthly information is available regarding Coffee Co.'s manufacturing costs and production volumes. Month Total Pounds of coffee Number of tea Boxes of chai Manufacturing beans produced bags produced produced Costs April, 2017 $1,709,880 3,800 30,000 750 May. 2017 $1,708,550 3,350 22,500 1,050 June, 2017 $1,667,130 2.750 15,000 1,200 July, 2017 $2,647,000 4,780 20,300 2,700 August, 2017 $1,918,680 4,330 15,000 1,580 September, 2017 $1,907.030 3,950 21,000 1,800 October, 2017 $1,785,650 3,830 22,500 1,050 November, 2017 $1,569,750 2,530 15,800 900 December, 2017 $1,698,350 2,980 16,500 1,280 January, 2018 $1,904,000 4,250 26,300 1,580 February, 2018 $1,906,530 3,950 21,000 1,800 March, 2018 $1,596,150 3,150 25,500 600 1. Using Excel, prepare a multiple regression analysis to determine the unit cost of each product. 2. What is the cost-estimating equation based on your multiple regression analysis? 3. How much of the variation in monthly cost is explained by your cost-estimating equation? Do you think tha this equation does a good job estimating production costs? Why or why not. 4. Coffee Co. plans to produce 4,000 pounds of coffee beans, 27,000 teabags, and 800 boxes of chai in May 2018. Using your cost-estimating equation, what is the estimated total manufacturing cost for May 2018? 5. You have a special-order opportunity (assume that you have enough excess capacity to complete the order). A customer has offered to buy 500 boxes of chair for $425 per box. Should you accept the order? Why or why not

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Corporate Finance

Authors: Stephen Ross, Randolph Westerfield, Jeffrey Jaffe, Bradford Jordan

12th edition

1259918947, 1260091908, 978-1259918940

More Books

Students also viewed these Accounting questions