Compute total production for the entire company

Assignment Help Business Management

Reference no: EM1368473

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: EM1368473

Questions Cloud

Explain including and the standard elements of a contract : Explain including the above list and the standard elements of a contract and you are to also include the following clauses into your formal

Calculating marginal cost : If the demand elasticity for a product is -2, and a profit-maximizing company sells the product for $10, determine its marginal cost?

Construct a model of irrational behavior : Economists are often criticized for making assumptions. Explain why are assumptions necessary? To think about this, you might consider an assumption that is often made,

Implementation plan for word processing software application : Word processing software application. Boardman plans to hire Smith Systems Consulting to help them analyze their options and to create the implementation plan.

Compute total production for the entire company : Explain You are automating the weekly production reports so that you can easily Compute total production for the entire company each week.

Economic and opportunity cost : You must select between sports training or working full time. If you choose sports training, you will have less of a social life. You will also pay $20,000 A year for training, but you will get $15,00 grant.

Calculate net present value of benefits : Corporation A is planning the purchase of a new machine that would lower cash outflow. The cost of the machine is 30,000. The annual reduction in cash flows is:

Draw a proposed catalytic cycle : Draw the enantiomer of proline which would give rise to the absolute stereochemistry and draw a proposed catalytic cycle for the transformation and how does the catalyst activate the substrate

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?

User Account

All Pages