Explain the managers will e-mail their weekly reports

Assignment Help Business Management

Reference no: EM1368465

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:
Note: This is a two part question.

1.) 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 number of mini-gizmos produced by the entire company in a week.

2.) 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 header with the date and your name to each page. What is the easiest way to do this? Explain the process.

Reference no: EM1368465

Questions Cloud

Write problems and issues associated with internet databases : Over 70% of web applications use database to store persistent data. Write some of the problems and issues associated with internet databases?

Strategy for internalizing positive externalities : Some real estate economists have argued that anchor stores in shopping malls create significant externalities for overall sales.

How recursion terminate in array : Continue in this fashion until entire array is read. Then recursively determine a candidate for B; this is candidate for A (why?). How does the recursion terminate?

Question on opportunity cost : Think about the trade off in work and leisure during a given day, and from day to day. During a given day, does opportunity cost of work rise, decline, or remain constant with each additional hour of work?

Explain the managers will e-mail their weekly reports : Explain The managers will e-mail their weekly reports to you on Monday of the following week and You will then produce the summary report. Explain the process for doing this and Give a sample formula to total the number of mini-gizmos produced by ..

Describe why analyst needs to understand how people think : Describe why an analyst requires to understand how people think, how they learn, how they react to change, how they communicate, and how they work.

Explain and contrast the dynamics between dominant cultures : Explain and Contrast the dynamics between dominant cultures and subcultures either in a work setting or in society.

Write algorithm to calculate the volume of water : Write an algorithm to calculate the volume of water in cubic feet, flowing through pipe of diameter d in feet, with a velocity of v feet per second.

Details of investing in market based portfolio : Based on current dividend yields and expected capital gains, expected rates of return on portfolios A and B are 11 percent and 14%, respectively. The beta of A is 0.8, while that of B is 1.5.

User Account

All Pages