The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | May 2017 |
| Last Sign in: | 408 Weeks Ago, 5 Days Ago |
| Questions Answered: | 66690 |
| Tutorials Posted: | 66688 |
MCS,PHD
Argosy University/ Phoniex University/
Nov-2005 - Oct-2011
Professor
Phoniex University
Oct-2001 - Nov-2016
Please let me know how much the charge is for this assignment. Please contact me by email or thru your website only. I will pay via PayPal as soon as I read your post.
Â
Dave Etmund
Project 3 Academic Honesty Policy Please make sure you read the academic honesty policy, since I want to make sure everyone realizes that they should not be discussing this exam outside the discussion board. This is an individual assignment and should be completed by each student on their own. I realize some of you maybe best friends or relatives, but this is an individual assignment and you should not be working as a team. Type in your name here: Worth 10 pts. You will be graded on the accuracy of your answer and usage of cell referencing in the DATA area. Covers material in chapters 7 and 8. DATA ABC, Inc. is a newly organized manufacturing business this year. The following company's costs and expenses are: Sales price per unit Manufacturing costs: Fixed Costs Variable Costs Direct materials Direct labor Variable Manufacturing overhead Fixed Manufacturing overhead Period expenses: Variable Selling and administrative expenses Fixed Selling and Administrative expenses Totals Units produced units Units sold Required: Use the information in the DATA field above using cell referencing to answer the following requirements. 1. Calculate the unit cost for variable costing. Review Exhibit 8-2 on page 328. 2. Calculate the unit cost for absorption costing. Review Exhibit 8-2 on page 328. 3. Prepare an absorption-costing income statement. Review Exhibit 8-3 on page 329. 4. Prepare a variable-costing income statement. Review Exhibit 8-3 on page 329. 5. Reconcile the differences in income that you calculated in #3 and #4 using exhibit 8-4 on page 330 as your guide or use the shortcut reconciliation on page 330-331. 6. Calculate the breakeven point in units. Reference page 279. 7. Calculate the breakeven point in sales dollars. 8. Calculate the safety margin. 10. Calculate the operating leverage . Reference page 296 11. What if sales volume increases by 5% how much will income increase in percentage terms? Make sure you...
| Type in your name here: | Â | Worth 10 pts. | Â | Â | Â | Â | Â | Grading Rubric: | Â | Â | Â | |||
| Project 3 is due by Tuesday, October 16th. Send via the assignment area and make sure you save your file with first initial of first name and last name. | Requirement | Points |  |  |  | |||||||||
| You will be graded on the accuracy of your answer and usage of cell referencing in the DATA area. | Covers material in chapters 7 and 8. | Â | Â | 1 | 0.5 | Â | Â | Â | ||||||
| Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | 2 | 1 | Â | Â | Â |
| DATA | Â | Â | Â | Â | Â | Â | Â | Â | Â | 3 | 1 | Â | Â | Â |
| ABC, Inc. is a newly organized manufacturing business this year. | Â | Â | Â | Â | Â | Â | 4 | 1 | Â | Â | Â | |||
| The following company's costs and expenses are: | Â | Â | Â | Â | Â | Â | 5 | 1 | Â | Â | Â | |||
| Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | 6 | 1 | Â | Â | Â |
| Â | Sales price per unit | $80 | Â | Â | Â | Â | Â | Â | 7 | 0.5 | Â | Â | Â | |
| Â | Manufacturing costs: | Â | Fixed Costs | Variable Costs | Â | Â | 8 | 0.5 | Â | Â | Â | |||
| Â | Â | Â | Direct materials | Â | Â | $8 | Â | Â | Â | 9 | 0.5 | Â | Â | Â |
| Â | Â | Â | Direct labor | Â | Â | 10 | Â | Â | Â | 10 | 0.5 | Â | Â | Â |
| Â | Â | Â | Variable Manufacturing overhead | Â | Â | 4 | Â | Â | Â | 11 | 0.5 | Â | Â | Â |
| Â | Â | Â | Fixed Manufacturing overhead | Â | $120,000 | Â | Â | Â | Â | 12 | 1 | Â | Â | Â |
| Â | Â | Period expenses: | Â | Â | Â | Â | Â | Â | 13 | 1 | Â | Â | Â | |
| Â | Â | Â | Variable Selling and administrative expenses | Â | 6 | Â | Â | Â | Total pts. Possible |
10 | Â | Â | Â | |
| Â | Â | Â | Fixed Selling and Administrative expenses | 10,000 | Â | Â | Â | Â | Â | Â | Â | Â | Â | |
| Â | Â | Totals | Â | Â | $130,000 | $28 | Â | Â | Â | Â | Â | Â | Â | Â |
| Â | Units produced | 6,000 | units | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | |
| Â | Units sold | 5,900 | units | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | |
| Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
| Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
| Required: | Use the information in the DATA field above using cell referencing to answer the following requirements. | Â | Â | Â | Â | Â | Â | Â | Â | Â | ||||
| 1. Calculate the unit cost for variable costing. Review Exhibit 8-2 on page 328. |  |  |  |  |  |  |  |  |  |  | ||||
| 2. Calculate the unit cost for absorption costing. Review Exhibit 8-2 on page 328. |  |  |  |  |  |  |  |  |  |  | ||||
| 3. Prepare an absorption-costing income statement. Review Exhibit 8-3 on page 329. |  |  |  |  |  |  |  |  |  |  | ||||
| 4. Prepare a variable-costing income statement. Review Exhibit 8-3 on page 329. |  |  |  |  |  |  |  |  |  |  | ||||
| 5. Reconcile the differences in income that you calculated in #3 and #4 using exhibit 8-4 on page 330 as your guide or use the shortcut reconciliation on page 330-331. |  |  |  |  |  | |||||||||
| 6. Calculate the breakeven point in units. Reference page 279. |  |  |  |  |  |  |  |  |  |  |  | |||
| 7. Calculate the breakeven point in sales dollars. |  |  |  |  |  |  |  |  |  |  |  | |||
| 8. Calculate the safety margin. |  |  |  |  |  |  |  |  |  |  |  |  | ||
|  9. What does the margin of safety mean? Reference page 285. Your answer should be at least 75 words. |  |  |  |  |  |  |  |  |  |  | ||||
| 10. Calculate the operating leverage . Reference page 296 |  |  |  |  |  |  |  |  |  |  |  | |||
| 11. What if sales volume increases by 5% how much will income increase in percentage terms? Make sure you have read over the DOL discussion and |  |  |  |  |  |  | ||||||||
| understand the multiplier impact of changes in sales volume that occurs based on DOL. | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | ||||
| 12. What if the direct material cost per unit increases from $8 a unit to $10, what will be the new breakeven in units? Explain why it changed. |  |  |  |  |  |  |  | |||||||
| You should only have to change the direct labor in the data area and actually all your answers should be updated. Please put the direct material cost back to the original number once you have answered the question? |  | |||||||||||||
| 13. What if the manufacturing overhead cost decreases from 120,000 to 115,000, what will be the new breakeven in units? Explain why it changed. |  |  |  |  |  |  |  | |||||||
| You should only have to change the fixed MOH in the data area and actually all your answers should be updated. Please put the fixed MOH cost back to the original number once you have answered the question? |  | |||||||||||||
| Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
| Solution: | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
| 1. | Â | Â | Â | 2. | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
| Â | Â | Variable costing | Â | Absorption Costing | Â | Â | Â | Â | Â | Â | Â | Â | Â | |
| Direct materials | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | |
| Direct labor | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
| Variable overhead | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | |
| Fixed overhead | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | |
| Total per unit cost | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | |
| Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
| Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
| 3. | Â | Â | ABC Company Inc. | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
| Â | Â | Â | Absorption Costing Income statement | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
| Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
| Sales revenue | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
| Less: Cost of goods sold | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | |
| Gross Margin | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
| Less:Â Selling and administrative expenses | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | |||
| Variable | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
| Fixed | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
| Net income | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
| Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
| Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
| 4. | Â | Â | ABC Company Inc. | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
| Â | Â | Â | Variable Costing Income statement | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
| Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
| Sales Revenue | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | |
| Less: Variable Expenses: | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | |
| Â | Variable manufacturing costs | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | ||
| Â | Variable Selling and administrative costs | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | ||
| Contribution margin | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | |
| Less: Fixed Expenses: | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | |
| Â | Fixed manufacturing overhead | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | ||
| Â | Fixed selling and Administrative expenses | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | ||
| Net income | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
| 5. | I am using a modification of the short cut method on page 331 as my model. | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | |||
| Change in inventory: | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | |
| Units produced | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | |
| Units sold | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
| Increase in inventory | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | |
| Fixed overhead rate | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | |
| Difference in fixed overhead expensed | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | ||
| Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
| Net income: | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
| Absorption costing | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | |
| Variable costing | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | |
| Difference | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
| Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
| 6. | Break even in units |  |  |  |  |  |  |  |  |  |  |  |  | |
| Â | Units | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
| Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
| 7. | Break even in sales $ | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | ||
| Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
| Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
| Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
| 8. | Safety Margin |  | On page 297 I realize the author uses budgeted sales revenue in the margin of safety calculation, but if you are |  |  |  | ||||||||
|  |  |  |  | given the actual sales revenue you can replace budgeted sales with actual sales, which you should do for #8. |  |  |  | |||||||
| Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
|  9. What does the margin of safety mean? Be very explicit in your answer, so I know you understand this concept and the importance of it to managers. |  |  |  |  |  |  | ||||||||
| Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
| Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
| Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
|  10. Calculate the operating leverage . Reference page 296 |  |  |  |  |  |  |  |  |  |  |  | |||
| Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
| Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
| 11. What if sales volume increases by 5% how much will income increase in percentage terms? Make sure you have read over the Operating leverage discussion and |  |  |  |  |  | |||||||||
| understand the multiplier impact of changes in sales volume that occurs based on operating leverage. | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | ||||
| Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
| Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
| 12. What if the direct material cost per unit increases from $8 a unit to $10, what will be the new breakeven in units? Explain why it changed. |  |  |  |  |  |  |  | |||||||
| You should only have to change the direct labor in the data area and actually all your answers should be updated. Please put the direct material cost back to the original number once you have answered the question? |  | |||||||||||||
| Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
| Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
| Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
| 13. What if the manufacturing overhead cost decreases from 120,000 to 115,000, what will be the new breakeven in units? Explain why it changed. |  |  |  |  |  |  |  | |||||||
| You should only have to change the fixed MOH in the data area and actually all your answers should be updated. Please put the fixed MOH cost back to the original number once you have answered the question? |  | |||||||||||||
| Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
Hel-----------lo -----------Sir-----------/Ma-----------dam----------- Â----------- -----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------acq-----------uis-----------iti-----------on -----------of -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------. P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll