| Value given | |||
| Direct material cost per unit | $2.50 | ||
| Direct labor cost per unit | $0.75 | ||
| Variable manufacturing overhead cost per unit | $0.25 | ||
| Fixed manufacturing overhead costs | $6,000.00 | ||
| Total fixed selling and administrative costs | $5,000.00 | ||
| Sales price per unit | $8.00 | ||
| Pints of gelato produced | 12,000.00 | ||
| Pints of gelato sold | 11,500.00 | ||
| Requirement 1 | |||
| Computation of product cost per unit | |||
|
Absorption Costing |
Variable Costing |
||
| Direct Material costs | 2.50 | 2.50 | |
| Direct Labor costs | 0.75 | 0.75 | |
| Variable Manufacturing Overhead costs | 0.25 | 0.25 | |
| Fixed Manufacturing Overhead costs | 0.50 | - | Refer Note 1 |
| Product cost per unit | 4.00 | 3.50 | |
| Note 1 | |||
| Fixed Manufacturing CPU = Fixed Manufacturing Overhead/Units Produced | |||
| =6000/12000 | |||
| =0.50 | |||
| Requirement 2 | |||
| Computation of balance in Finished Goods inventory on May 31,2018 | |||
| Beginning inventory in units | - | ||
| Units produced | 12,000 | ||
| Units available for sale | 12,000 | ||
| Units sold | 11,500 | ||
| Ending inventory in units | 500 | ||
|
Absorption Costing |
Variable Costing |
||
| Ending inventory in units | 500 | 500 | |
| Product cost per unit | 4 | 3.5 | |
| Balance in Finished Goods Inventory | 2000 | 1750 | |
| Requirement 3 | |||
| Statement of income | |||
| TIGER MOUNTAIN GELATO | |||
| Income Statement ( Absorption Costing) | |||
| Sales ( 11,500 units * $ 8) | $92,000 | ||
| Less: Cost of goods sold | |||
| Opening Inventory | $0 | ||
| Add: Cost of goods manufactured (12000* $ 4) | $48,000 | ||
| Cost of goods available for Sale | $48,000 | ||
| Less: Closing Inventory ( 500 * $ 4) | $2,000 | ||
| Cost of Goods Sold | $46,000 | ||
| Gross profit | $46,000 | ||
| Less:Fixed Selling and Administrative costs | $5,000 | ||
| Net Operating Income | $41,000 | ||
| TIGER MOUNTAIN GELATO | |||
| Income Statement ( Variable Costing) | |||
| Sales ( 11,500 units * $ 8) | $92,000 | ||
| Less: Cost of goods sold | |||
| Opening Inventory | $0 | ||
| Add: Cost of goods manufactured (12000* $ 3.50) | $42,000 | ||
| Cost of goods available for Sale | $42,000 | ||
| Less: Closing Inventory ( 500 * $ 3.50) | $1,750 | ||
| Cost of Goods Sold | $40,250 | ||
| Gross profit | $51,750 | ||
| Less: | |||
| Fixed Manufacturing costs | $6,000 | ||
| Fixed Selling and Administrative costs | $5,000 | ||
| Net Operating Income | $40,750 | ||
| Requirement 4 | |||
| Reconciliation of difference between operating income & Finished Goods Inventory | |||
|
Absorption Costing |
Variable Costing |
Difference | |
| Operating Income | $41,000 | $40,750 | $250 |
| Finished Goods Inventory | $2,000 | $1,750 | $250 |
| Reconciliation of difference between operating income | |||
| Net operating income under variable costing | $40,750 | ||
|
Add- Fixed Manufacturing overheads deferred in Inventory ( 500 * $ 0.50) |
$250 | ||
| Net operating income under absorption costing | $41,000 | ||
2 BIUDAYA 2 > Requirements Prepare income statements in good form for Tiger Mountain Gelato for...
I need to use the cell references to get my
answers
DATA Tiger Mountain Gelato incurs the following costs for its premium ice cream in May 2018: Direct materials cost per pint $ 2.50 per pint Direct labor cost per pint 0.75 per pint Variable manufacturing overhead cost per pint 0.25 per pint Fixed manufacturing overhead costs 6,000 per month Total fixed selling and administrative costs 5,000 per month Sales price per pint 8.00 per pint Pints of gelato produced...
I need to use the cell
references to get my answers
Requirement 2 Calculate the balance in Finished Goods Inventory on May 31, 2018, using absorption costing and variable costing. (Always use cell references and formulas where appropriate to receive full credit. Ifyou copy/paste from the Instruction tab you will be marked wrong. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values.) Beginning Inventory in units Units produced Units available for sale...
erform: Instructions Prepare the company's income statement for the year ended December 31, 2018, complete with an appropriate heading. a. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values to be subtracted. b. Check your spelling carefully and do not abbreviate. (Always use cell references and formulas where appropriate to receive full credit If you copy/paste from the Instructions tab you will be marked wrong.) Total Points 1 The Financial Statements 2...
i Cost-Volume-Profit Analysis CVP exercises The Dell-Sub Shop owns and operates six stores in and around Minneapolis. You are given the following corporate budget data for next year: Revenues Fixed costs Variable costs $11,000,000 $3,000,000 $7,500,000 10 Variable costs change based on the number of subs sold. 12 Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. Cell references and formulas should be based on the...
Requirements Prepare the sales budget, including a separate section that details the type of sales made (cash versus credit) for the first three months of the year, as well as a summary budget for the quarter. 2 Prepare the production budget for the first three months of the year, as well as a summary budget for the quarter. a. Enter all amounts as positive values. Do NOT use parentheses or a minus sign for amounts to be subtracted Prepare the...
Excel with formulas and links.
Thank you very very very much.
1 Cost-Volume-Profit Analysis 2 Contribution margin, gross margin, and margin of safety. Juicy Beauty manufactures and sells a face cream to small specialty stores in the greater Los Angeles area. It presents the monthly operating income statement shown here to George Lopez, a potential investor in the business. Help Mr. Lopez understand Juicy Beauty's cost structure. The monthly operating income statement can be found on the 4Ц "INCOM ESTATE...
Stockholders' Equity Prepare the stockholders' equity section of a balance sheet The financial statements of Ridgeline Employment Services, Inc., reported the following accounts $1,600,000 100,000 660,000 200,000 1,000,000 Paid-in capital in excess of par $334,000 Total revenue:s Notes payable (short-term) Common stock, $0.01 par 600,000 shares issued Long-term debt 50,000 Accounts payable 6,000 Retained earnings Other current liabilities 25,000 Total expenses Use the blue shaded areas on the ENTERANSWERS tab for inputs Always use cell references and formulas where appropriate...
Excel with formulas please and
thank you!
ProChem, Inc., produces chemicals for large biotech companies. It has the following data for manufacturing overhead costs during August 2017: Variable Fixed 35,000$ 16,500 15,200 16,000 Actual costs incurred Costs allocated to products Flexible budget Actual input x budgeted rate 31,500 Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instruction tab you will...
1. Prepare an income statement for Del Campo for 2019 and 2018 under both the cash and the accrual basis of accounting. (Always use cell references and formulas, including $0 balances, where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong.) Accrual Basis 2019 2018 Cash Basis 2019 2018 Operating expenses: Operating income 2. Compute operating cash flow for both years under cash and accrual bases. (Always use cell references and formulas...
Instructions Using the straight-line method of depreciation, calculate the depreciation expense, accumulated depreciation balance, and book value for each of the four years of the van's useful life. a. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values to be subtracted. (Always use cell references and formulas where appropriate to receive full credit. If you copy paste from the Instruction tab you will be marked wrong.) Total Points Total Points A B...