Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Managers at Go Pirates Corp... Part II please Uue Managers of Go Pirates Corp. are concerned that the company's costs of production have gone wild.
Managers at Go Pirates Corp...
Uue Managers of Go Pirates Corp. are concerned that the company's costs of production have gone wild. The Chief Financial Officer brings you the following historic data: Period Quarter 1, 2018 Quarter 2, 2018 Quarter 3, 2018 Quarter 4, 2018 Quarter 1, 2019 Quarter 2, 2019 Quarter 3, 2019 Quarter 4, 2019 Units 1.120 980 1.260 1,340 1,280 1,300 1.420 Costs $99,598,60 $97.880.40 $103.068.80 $105, 520 $103.776.40 S104,202.00 $107.411.60 $109,333.00 1,500 Go Pirates' selling price is $60 per unit Required: Part (Excel): Using the High-Low method: a. Estimate the company's cost formula b. Estimate the total cost of producing 1,200 units. 6. Calculate the breakeven point in dollar sales d. Prepare the Contribution Format Income Statement when 1,200 units are sold. e. Compute the Degree of Operating Leverage when 1.200 units are sold. Compute Net Operating Income if sales increased 120 units above this level Part II (Excel): Using Excel tools: a. Estimate the company's cost formula b. Estimate the total cost of producing 1,200 units C. Calculate the breakeven point in dollar sales. d. Prepare the Contribution Format Income Statement when 1,200 units are sold. e. Compute the Degree of Operating Leverage when 1200 units are sold. Compute Net Operating Income if sales increased 120 units above this level. Part (Microsoft Wordy: Prepare a summary of the above results which includes: a. A table summarizing the results of Parts and above for each of the requirements. b. A discussion of possible reasons why the results Part I and Part Ill differ. Ensure that you use proper spreadsheet techniques according to the Silman Spreadsheet Design Guidelines posted in Blackboard). Your written report should be dear, concise yet thorough, and free of spelling and grammatical errors. Please upload your Excel Spreadsheet and Word Document to the Project 1 assignment function on Blackboard by 3pm on October 18, 2019 Part II please
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started