Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Inventory Forecast (Fiscal Year 2021) Finished goods: Box type C Box type P Inventory January 1, 2021 10,000 boxes 5,000 boxes Desired Ending Inventory
Inventory Forecast (Fiscal Year 2021) Finished goods: Box type C Box type P Inventory January 1, 2021 10,000 boxes 5,000 boxes Desired Ending Inventory December 31, 2021 35,000 boxes 30,000 boxes Requirements: 1. Using Microsoft Excel, analyze the costs and expenses detailed on the first page, using regression analysis to separate mixed costs. Determine per unit costs for direct materials and direct labor for each type of box (See Exhibit A). 2. Prepare a table detailing variable costs for each type of box, and fixed costs. Include direct materials and direct labor in your table, as well as unit sales, unit production, unit-selling price, and adjust for inflation (See Exhibit B). Exhibit B will include your unit variable costs and your monthly fixed expenses. Note: Regression Analysis of mixed costs should be prepared on a separate worksheet. In addition, all three worksheets (unit costs for direct materials and direct labor, the variables worksheet, and regression analysis worksheet) should be linked to each other. 3. Prepare an annualized contribution income statement, in excellent form, using Microsoft Excel. You will also prepare a CVP Graph linked to your contribution income statement. You will have to link the income statement to a table in order to generate a graph. In addition, your income statement must be linked to your variable work sheet prepared in Part I (This allows you to change your variables without disturbing the integrity of the income statement). The linkage between your worksheets and graphs supports sensitivity (what-if) analysis. Use the sample format found on Exhibit C. 4. Prepare an absorption costing income statement like the one found on Exhibit D. The per unit cost uses the weighted-average unit cost (multiple products) and are linked from the contribution margin income statement to the absorption costing income statement. Note: per unit cost for fixed manufacturing overhead is calculated based on the number of units produced during the year. 5. In a coherent memo to the management of Obfuscated Container Corporation (OCC), explain/reconcile the difference in net income between the absorption costing and variable costing (contribution) income statements. Be sure to explain clearly to management why there are differences in net income used for external financial reporting purposes (absorption costing) and net income used in decision making (variable costing). Use the following Memorandum format: Memorandum Date: March 23, 2022 To: The Management of Obfuscated Container Corporation (OCC) 5 898 words Text Predictions. On
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