YTHOMIT ONLY ALL OTHERS PLEASE DO NOT MESSAGE ME

profileWiseOne
madisonk_m2a3.xlsx

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.
30.0 40.0 50.0 60.0 70.0 80.0 90.0 30.0 40.0 50.0 60.0 70.0 80.0 90.0 24000.0 32000.0 40000.0 48000.0 56000.0 64000.0 72000.0 30.0 40.0 50.0 60.0 70.0 80.0 90.0 30.0 40.0 50.0 60.0 70.0 80.0 90.0 35200.0 37600.0 40000.0 42400.0 44800.0 47200.0 49600.0 30.0 40.0 50.0 60.0 70.0 80.0 90.0

No.of Trades

Total revenue