# View the step-by-step solution to: You've just joined the staff of the XYZ Manufacturing Company

This question was answered on Aug 26, 2010. View the Answer
You’ve just joined the staff of the XYZ Manufacturing Company (XYZ, for short). XYZ manufactures only one product—the gizmo. It comes in two sizes, the mini-gizmo and the magna-gizmo. Both are difficult to manufacture, and consequently, the company closely monitors rejected units. The company has three locations each of which produces both the mini and the magna-gizmos. You are automating the weekly production reports so that you can easily calculate total production for the entire company each week.

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.
Sign up to view the entire interaction

We need you to clarify your question for our tutors! Clarification request:... View the full answer

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors and customizable flashcards—available anywhere, anytime.

### -

Educational Resources
• ## -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access or to earn money with our Marketplace.

Browse Documents
• ## 890,990,898

Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

• ## 890,990,898

Flashcards

Browse existing sets or create your own using our digital flashcard system. A simple yet effective studying tool to help you earn the grade that you want!

Browse Flashcards