YTHOMIT ONLY ALL OTHERS PLEASE DO NOT MESSAGE ME
Sheet1
| P16A-17B | |||||||||||||||
| 1 | Draw a time line for assembly department | Time Line for Assembly Department | |||||||||||||
| Units Started | Transferred out | WIP at end completed | Direct material | Direct Labor | Manufacturing Overhead | ||||||||||
| 100,000 | 76,100 | 40% | 375,720 | 157,700 | 98,505 | ||||||||||
| 2 | Computed the equivalent units | ||||||||||||||
| Sue Electronics | |||||||||||||||
| Cost per Equivalent Unit - Assembly Department | |||||||||||||||
| For the month ended April 30 | |||||||||||||||
| Direct material | Conversion Cost | Total | |||||||||||||
| Units completed and transferred out | 76,100 | 76,100 | |||||||||||||
| WIP ending | 23,900 | 9,560 | |||||||||||||
| 100,000 | 85,660 | ||||||||||||||
| Cost added | |||||||||||||||
| Direct material | 375,720 | ||||||||||||||
| Direct Labor & Mfg. OH | 256,205 | ||||||||||||||
| Cost per unit | 3.76 | 2.99 | 6.75 | ||||||||||||
| 3 | Assigned total costs in the assembling department | ||||||||||||||
| Sue Electronics | |||||||||||||||
| Assignment of total cost - Assembly department | |||||||||||||||
| For the month ended April 30 | |||||||||||||||
| Direct material | Conversion Cost | Total | |||||||||||||
| Units completed and transferred out | 285,923 | 227,611 | 513,534 | ||||||||||||
| WIP ending | 89,797 | 28,594 | 118,391 | ||||||||||||
| Total cost accounted for | 375,720 | 256,205 | 631,925 | ||||||||||||
| 4 | Prepared T-account for WIP inventory | ||||||||||||||
| Work in Process Inventory - Assembly | |||||||||||||||
| Opening Balance | - 0 | Transferred Out | 513,534 | ||||||||||||
| Direct Materials | 375,720 | WIP ending | 118,391 | ||||||||||||
| Direct Labor | 157,700 | ||||||||||||||
| Manufacturing Overhead | 98,505 | ||||||||||||||
| 631,925 | 631,925 | ||||||||||||||
| P16A-19B | |||||||||||||||
| 1 | Timeline for Preparation Department | ||||||||||||||
| Timeline for Preparation Department | |||||||||||||||
| Beginning WIP | Started Production(Sheets) | Completed and transferred to Compression in March | Ending WIP | Cost Adding during march | Wood | Adhesive | Direct Labor | manufacturing Overheads | Total Costs | ||||||
| 0 | 3300 | 1900 | 1400 | $ 2,600 | $ 1,365 | $ 640 | $ 2,445 | $ 7,050 | |||||||
| 2 | Computed the equivalent units | ||||||||||||||
| Wood | Adhesive | Conversion Cost | Total | ||||||||||||
| Units completed and transferred out | 1,900 | 1,900 | 1900 | ||||||||||||
| WIP ending | 1,400 | 1,400 | 630 | ||||||||||||
| 3,300 | 3,300 | 2,530 | |||||||||||||
| Cost added | |||||||||||||||
| Direct Material | 2,600 | 1365 | |||||||||||||
| Direct Labor & Mfg. OH | 3085 | ||||||||||||||
| Cost per unit | 0.79 | 0.41 | 1.22 | 2.42 | |||||||||||
| 3 | Assigned Total Costs | ||||||||||||||
| Wood | Adhesive | Conversion Cost | Total | ||||||||||||
| Units completed and transferred out | 1,497 | 786 | - 0 | 2,317 | 4,600 | ||||||||||
| WIP ending | 1,103 | 579 | - 0 | 768 | 2,450 | ||||||||||
| 2,600 | 1,365 | - 0 | 3,085 | - 0 | 7,050 | ||||||||||
| 4 | Journal Entries | ||||||||||||||
| WIP Inventory- Preparation Dept. | 7,050 | ||||||||||||||
| Material Inventory | 3965 | ||||||||||||||
| Wages Payable | 640 | ||||||||||||||
| Manufacturing OH | 2445 | ||||||||||||||
| WIP Inventory-Compression Dep't. | 4,600 | ||||||||||||||
| WIP Inventory- Preparation Dep't. | 4600 | ||||||||||||||
| 5 | Prepared T-account for WIP inventory | ||||||||||||||
| Work in Process Inventory - Preparation | |||||||||||||||
| Opening Balance | Transferred Out | 4,600 | |||||||||||||
| Direct Materials | 3965 | WIP ending | 2,450 | ||||||||||||
| Direct Labor | 640 | ||||||||||||||
| Manufacturing Overhead | 2445 | ||||||||||||||
| 7,050 | 7,050 | ||||||||||||||
| P18-24A | |||||||||||||||
| 1 | Computed revenue and VC for each show | ||||||||||||||
| Revenue 1250*50 | $ 62,500 | ||||||||||||||
| Variable Costs | |||||||||||||||
| Cast Earnings | 21,000 | ||||||||||||||
| Program Printing Cost | 8,400 | ||||||||||||||
| Total Variable Costs each show | $ 29,400 | ||||||||||||||
| Contribution Margin Each show | 33,100 | ||||||||||||||
| 2 | Computed number of shows BP must perform to break even | ||||||||||||||
| Break Even=FC/CM | 14 | Shows | |||||||||||||
| 459000/33100 | |||||||||||||||
| 3 | Computed number of shows needed to earn $3,825,000 profit | ||||||||||||||
| Desired Profits | $ 3,825,000 | ||||||||||||||
| Fixed Costs | 459,000 | ||||||||||||||
| desired Contribution Margin | 4,284,000 | ||||||||||||||
| Required No. of Shows | 130 | ||||||||||||||
| 4 | Prepared BP’s contribution margin income statement | ||||||||||||||
| No. of shows | 130 | ||||||||||||||
| Revenue 1250*50*130 | $ 8,125,000 | ||||||||||||||
| Variable Costs | |||||||||||||||
| Cast Earnings | 2,730,000 | ||||||||||||||
| Program Printing Cost | 1,092,000 | ||||||||||||||
| Total Variable Costs | $ 3,822,000 | ||||||||||||||
| Contribution Margin Total | 4,303,000 | ||||||||||||||
| Fixed Costs | 459,000 | ||||||||||||||
| Profits | $ 3,844,000 | ||||||||||||||
| P18-26A | |||||||||||||||
| 1 | Computed Big Time’s break even revenue in dollars | ||||||||||||||
| Average trade Revenue | $ 800 | ||||||||||||||
| Variable Costs: | |||||||||||||||
| payment to financial Planner | 9% | ||||||||||||||
| Advertising | 12% | ||||||||||||||
| Supplies & Postage | 4% | ||||||||||||||
| Usage Fee | 5% | ||||||||||||||
| Total variable Costs | 30% | ||||||||||||||
| Fixed Costs | |||||||||||||||
| Office Rent | 8,200 | ||||||||||||||
| Depreciation | 1,500 | ||||||||||||||
| Utilities | 2,300 | ||||||||||||||
| Special telephone Line | 1,300 | ||||||||||||||
| Brokerage | 2,900 | ||||||||||||||
| Salary | 11,800 | ||||||||||||||
| Total Monthly Fixed Cost | 28,000 | ||||||||||||||
| Average trade Revenue | $ 800 | ||||||||||||||
| Total variable Costs | 240 | ||||||||||||||
| CM | 560 | ||||||||||||||
| CM Ratio | 70% | ||||||||||||||
| BEP In Dollars= FC/CM Ratio | $ 40,000 | ||||||||||||||
| 2 | Computed dollar revenues needed to earn OI of $11,200 | ||||||||||||||
| Sales Revenue = | OI + | FC + | VC | ||||||||||||
| 56,000 | 11,200 | 28000 | 16800 | ||||||||||||
| 3 | Graphed Big Time’s CVP relationships | ||||||||||||||
| No. of Trades | Trade Revenue | Total Costs | |||||||||||||
| 30 | 24,000 | 35200 | |||||||||||||
| 40 | 32,000 | 37600 | |||||||||||||
| 50 | 40,000 | 40000 | |||||||||||||
| 60 | 48,000 | 42400 | |||||||||||||
| 70 | 56,000 | 44800 | |||||||||||||
| 80 | 64,000 | 47200 | |||||||||||||
| 90 | 72,000 | 49600 | |||||||||||||
| 4 | Computed new BEP if average revenues increased to $900 per trade | ||||||||||||||
| Average trade Revenue | $ 900 | ||||||||||||||
| Total variable Costs | 270 | ||||||||||||||
| CM | 630 | ||||||||||||||
| CM Ratio | 70% | ||||||||||||||
| BEP In Dollars= FC/CM Ratio | $ 40,000 | ||||||||||||||
| As there is no change in variable cost resulting no change in CM Ratio BEP in dollars will remain same but BEP in units (Trade) will come down as there is increase in revenue per trade. |
No.of Trades
Total revenue