Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
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
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started