Excel model spreadsheet by entering the required totals

Assignment Help Operation Management

Reference no: EM131277001

A distributor of prewashed shredded lettuce is opening a new plant and considering whether to use a mechanized process or a manual process to prepare the product. The manual process will have a fixed cost of $43,400 per month and a variable cost of $1.80 per 5-pound bag. The mechanized process would have a fixed cost of $84,600 per month and a variable cost of $1.30. per bag. The company expects to sell each bag of lettuce for $2.50. A. What is the break-even point for each process B. What is the monthly profit or loss if the company chooses the manual process and sells 70,000 bags per month? 22. A company makes two products - product A and product B which are sold at a profit per unit of $60 and $100, respectively. The three resources used to make these products are summarized in the table below. The excel model setup is provided in the Exam 1 Excel Template. Complete the excel model spreadsheet by entering the required totals calculations and use Solver to maximize the total profit. Use the results to answer the following questions. Product A Product B Total Resources Available Resource X 12 0 372 Resource Y 8 16 592 Resource Z 8 8 280

A. What is the total profit? ____________________

B. Product A number of units? ____________________

C. Product B number of units? ____________________

D. Resource X total? ____________________

show work please (excel)

Reference no: EM131277001

Questions Cloud

What do you think should count as ethical workplace behavior : Apply one or more of the five business ethics myths described in your text to your own ethical perspective. The author of the text believes many people are victims of these myths. How might one or more of these myths affect you—or how might they not ..

What are the main types of job evaluation schemes : What is a total rewards approach?- What is market pricing?- What is job evaluation?- What are the main types of job evaluation schemes?

How would you balance the rights of the teachers : What do you see as some of the outcomes from teachers in Chicago being on strike for more than two weeks for both the teachers, students, and the economy? How do you feel about this?

Members informed regarding continuous improvement efforts : List three methods your group has used to keep your project group members informed regarding continuous improvement efforts. Explain why these methods were used and whether they were effective.

Excel model spreadsheet by entering the required totals : A distributor of prewashed shredded lettuce is opening a new plant and considering whether to use a mechanized process or a manual process to prepare the product. The manual process will have a fixed cost of $43,400 per month and a variable cost of $..

What is the magnitude of the velocity gradient needed : Make use of the data in Appendix B to determine the dynamic viscosity of glycerin at 85°F Express your answer in both SI and BG units.

What are the main types of grade and pay structures : What is base pay management?- What is a grade structure?- What is a pay structure? - What are the main types of grade and pay structures?

Current ratio and quick ratio for sme petroleum : Calculate the current ratio and quick ratio for SME Petroleum. What is SME Petroleum's debt to equity ratio? How has the debt to equity position changed between 2010 and 2011? What is the net working capital of SME Petroleum?

Identify the stages of the brand development process : Identify the stages of the brand development process and describe the nature and importance of each by illustrating each stage with an example of the behavior a consumer might exhibit when going through that stage.

User Account

All Pages