Accounting Topic #5: Case 2
jandreg
acct640_case_2_performance_drinks_student_data2.xlsxMonthly Profit Report Trad'l
| PERFORMANCE DRINKS - MONTHLY PROFIT REPORT | |||||
| Basic | Hydration | Intensity | Post Workout | Total | |
| REVENUE | |||||
| Sales | $ 125,000 | $ 120,000 | $ 74,250 | $ 93,000 | $ 412,250 |
| COSTS | |||||
| Direct Materials | $ 40,000 | $ 50,000 | $ 31,000 | $ 33,000 | $ 154,000 |
| Direct Labor | $ 25,000 | $ 20,000 | $ 10,000 | $ 18,000 | $ 73,000 |
| Fringe Benefits on Direct Labor | $ 11,250.00 | $ 9,000.00 | $ 4,500.00 | $ 8,100.00 | $ 32,850.00 |
| Manufacturing Overhead | $ 43,750.00 | $ 35,000.00 | $ 17,500.00 | $ 31,500.00 | $ 127,750.00 |
| TOTAL COST | $ 120,000.00 | $ 114,000.00 | $ 63,000.00 | $ 90,600.00 | $ 387,600.00 |
| GROSS MARGIN | $ 5,000.00 | $ 6,000.00 | $ 11,250.00 | $ 2,400.00 | $ 24,650.00 |
| GROSS MARGIN RATIO | 4.00% | 5.00% | 15.15% | 2.58% | 5.98% |
| Annual Volume: | 100,000 | 80,000 | 45,000 | 60,000 | 285,000 |
| Unit Price: | $ 1.25 | $ 1.50 | $ 1.65 | $ 1.55 | $ 1.45 |
| Unit Cost: | $ 1.200 | $ 1.425 | $ 1.400 | $ 1.510 | $ 1.360 |
Mfg OHD
| PERFORMANCE DRINKS - MONTHLY MFG OHD COST REPORT | |
| Monthly Charge | |
| Indirect Labor | $ 55,000.00 |
| Fringe Benefits on Indirect Labor | $ 24,750.00 |
| Utilities | $ 5,000.00 |
| Processing Equipment - Depreciation | $ 10,000.00 |
| Preventative Maintenance | $ 10,000.00 |
| Information Technology | $ 23,000.00 |
| Total | $ 127,750.00 |
