Question: I need help with week 3 Bus 687 Capstone Quarterly Q3'24 SRO Q4'23A Q1'24A Q2'24A Q3'24 Q4'24 Sales Total Market Demand [Units] 2,485 3,234 4,142
I need help with week 3 Bus 687 Capstone Quarterly
| Q3'24 SRO | Q4'23A | Q1'24A | Q2'24A | Q3'24 | Q4'24 | |
|---|---|---|---|---|---|---|
| Sales | ||||||
| Total Market Demand [Units] | 2,485 | 3,234 | 4,142 | |||
| Lost Sales [Units] | 0 | 0 | 0 | |||
| Units Sold [Units] | 829 | 1,041 | 1,240 | |||
| Price [$] | $550.00 | $575.00 | $600.00 | |||
| Terms [Days] | 60 | 60 | 60 | |||
| Average Collection Period [Days] | 64.4 | 63.9 | 63.4 | |||
| Production | ||||||
| Raw Material On Order [Units] | 1,000 | 2,400 | 2,050 | |||
| Units Produced [Units] | 1,166 | 1,200 | 1,900 | |||
| Labor Force Hires [People] | 5 | 6 | 8 | |||
| Labor Force Layoffs [People] | 0 | 0 | 0 | |||
| Lines On Order [Units] | 0 | 0 | 3 | |||
| Planned Time | 1.28 | 0.90 | 1.01 | |||
| Effectiveness | 85.4% | 87.7% | 88.8% | |||
| Discretionary Costs | ||||||
| Quality Engineering Expense | $42,000.00 | $0.00 | $0.00 | |||
| Research Funding Expense | $0.00 | $0.00 | $0.00 | |||
| Project 01 Funding | R&D Decision | $0.00 | $0.00 | $0.00 | $25,000.00 | $25,000.00 |
| Project 02 Funding | $45,000.00 | $35,000.00 | $0.00 | $0.00 | $0.00 | |
| Project 03 Funding | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Inventory Rework Cost | $0.00 | $0.00 | $9,375.00 | |||
| Marketing Expense | $41,000.00 | $0.00 | $0.00 | |||
| Advertising Expense | $31,000.00 | $0.00 | $2,000.00 | |||
| Lean Six Sigma Expense | $25,000.00 | $0.00 | $95,999.00 | |||
| Building Lease and Utilities | $79,953.00 | $90,176.00 | $115,520.36 | |||
| Reports | ||||||
| Marketing Report | ||||||
| Business Intelligence Dashboard |
report
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
