Ans.(1) | Determination of Unit Product Cost (Under Variable Costing): | |||||
Particulars | Amt.($) | |||||
Direct Material | 135 | |||||
Direct Labor | 43 | |||||
Variable Manuf. Overhead | 37 | |||||
Cost per unit | $ 215 | |||||
Addison, Inc. | ||||||
Income Statement | ||||||
Particulars | Amt.($) | Amt.($) | ||||
Sales (4,500 x $83) | $ 1,890,000 | |||||
Variable Cost of Goods sold: | ||||||
Beginning Inventory | - | |||||
Production cost (5,000 units x $215) | $ 1,075,000 | |||||
Cost of Goods available for sale | 1,075,000 | |||||
Ending Inventory (500 units x $215) | 107,500 | 967,500 | ||||
Gross contribution margin | 922,500 | |||||
Variable Selling and administrative expenses(4,500 units x $45) | 202,500 | |||||
Contribution Margin | 720,000 | |||||
Less: Fixed cost | ||||||
Manufacturing Overhead | 210,000 | |||||
Selling and administrative | 190,000 | 400,000 | ||||
Net Operating Income | $ 320,000 |
Ans.(2) | Determination of Unit Product Cost (Under Absorption Costing): | |||||
Particulars | Amt.($) | |||||
Direct Material | 135 | |||||
Direct Labor | 43 | |||||
Variable Manuf. Overhead | 37 | |||||
Fixed Manuf. Overhead ($210,000 / 5,000) | 42 | |||||
Cost per unit | $ 257 | |||||
Addison, Inc. | ||||||
Income Statement | ||||||
Particulars | Amt.($) | Amt.($) | ||||
Sales (4,500 x $83) | $ 1,890,000 | |||||
Cost of Goods sold | ||||||
Beginning Inventory | ||||||
Production cost (5,000 units x $257) | $ 1,285,000 | |||||
Cost of Goods available for sale | 1,285,000 | |||||
Ending Inventory (500 units x $257) | 128,500 | 1,156,500 | ||||
Gross Profit | 733,500 | |||||
Less: Selling and administrative expenses: | ||||||
Variable (4,500 units x $45) | 202,500 | |||||
Fixed | 190,000 | 392,500 | ||||
Net Operating Income | $ 341,000 |
1 Addison, Inc. makes a single product, an indoor fireplace, and has provided data from last...
Addison, Inc. makes a single product, an indoor fireplace, and
has provided data from last year of operations. The Controller has
asked you to compare income statements if the company used the
variable costing approach vs. the absorption costing
report.
А B C D E 1 Addison, Inc. makes a single product, an indoor fireplace. Data for last year is as follows: 2 $420 5 6 7 $135 $43 $37 $210,000 8 9 3 Selling price per fireplace 4 Manufacturing...
Hayword, Inc uses weighted average costing and has two departments and has provided data related to its mixing department for the month of July. The Controller has asked you prepare a cost reconciliation report and provide the related computations. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. • Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a...
S&P Enterprises has provided data from the first three
months of the year. The Controller has asked you to prepare the
Cash Budget and the related Schedules for Expected cash collections
and Payments to suppliers. Use the information included in the
Excel Simulation and the Excel functions described below to
complete the task.Cell Reference: Allows you to refer to data
from another cell in the worksheet. From the Excel Simulation
below, if in a blank cell on the Budget Data...
JPL, Inc. has provided its sales and expense data for the most recent period. The Controller has asked you prepare a spreadsheet that shows the related CVP Analysis computations. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. • Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, B5" was entered, the formula would output the...
Hayword, Inc. uses weighted-average costing and has two departments and has provided data related to its mixing department for the month of July. The Controller has asked you prepare a cost reconciliation report and provide the related computations. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. . Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below.if in a blank cell,...
JPL, Inc. has provided its sales and expense data for the most recent period. The Controller has asked you prepare a spreadsheet that shows the related CVP Analysis computations. Use the information included in the Excel Simulation and the Excel functions described below to complete the task .Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, "-B5" 15 was entered, the formula would output the...
S&P Enterprises has provided data from the first three
months of the year. The Controller has asked you to prepare the
Cash Budget and the related Schedules for Expected cash collections
and Payments to suppliers. Use the information included in the
Excel Simulation and the Excel functions described below to
complete the task.
Cell Reference: Allows you to refer to data
from another cell in the worksheet. From the Excel Simulation
below, if in a blank cell on the Budget...
Need answers for the highlighted cells in question 1 and
2 (Formula's)
JPL, Inc. has provided its sales and expense data for the most recent period. The Controller has asked you prepare a spreadsheet that shows the related CVP Analysis computations. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. points • Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below,...
Jay Corporation has provided data from a two-year period to aid in planning. The Controller has asked you to prepare a contribution format income statement. Use the information included in the Excel Simulation and the Excel functions described below to complete the task • Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, "=B4" wa entered, the formula would output the result from cell B4,...
JPL, Inc. has provided its sales and expense data for the most recent period. The Controller has asked you prepare a spreadsheet that shows the related CVP Analysis computations. Use the information included in the Excel Simulation and the Excel functions described below to complete the task Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below,, if in a blank cell, "-B5" was entered, the formula would output the result...