The mini-gizmo is priced at $3.25 per unit. The magna-gizmo is priced at $7.00 per unit. The unit cost for a reject mini-gizmo is $1.75. The cost for a reject magna-gizmo is $3.50. Respond fully to the following questions regarding this task:
A - (TCO 1) You have decided to develop a worksheet for each manufacturing facility manager to submit each week. It should show total production and revenue, and total scrap and cost for each product for the week. Production of more than 25,000 magna-gizmos in a week, qualifies the facility manager for a bonus. Explain how you will set this up so that the managers enter only the number of units for each product’s production and rejects. There should be an indicator of some kind if the bonus is earned.
B - (TCO 5) The managers will e-mail their weekly reports to you on Monday of the following week. You will then produce the summary report. Explain the process for doing this. Give a sample formula to total the cost of mini-gizmo rejects for the entire company for the week.
C - (TCO 5) Each week, you will present the combined report to your boss, who wants to see both the summary and the individual sheets for each location. You want to add a custom footer with the date and your name to each page. What is the easiest way to do this? Explain the process.
D - (TCO 3) Describe the graph that you would create to accompany the report in Part C. Include formatting considerations to make important facts stand out.
Recently Asked Questions
- Community Project Paper Locate a local Community project for review. CITE REFERENCES Consider how a local community project aligns with the city's governance
- Generate the point forecasts and prediction intervals, using ARIMA (1, 1, 0) +C and ARIMA (0, 2, 2), respectively. Compare and evaluate the point forecasts
- The financial manager at Kyser Jones is considering two mutually exclusive projects with the following projected cash flows: Projected Cash Flows Year Project