d) The revenue for the mechanized process at the break-even quantity = $117857 (round your response to the nearest whole number). e) For monthly sales of 60,000 bags, for the option with manual processing, A&Z Lettuce Products will have a profit of $ (round your response to the nearest whole number and include a is negative)

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question
Question E
**Title: Break-Even Analysis for A&Z Lettuce Products**

Zania Azlett and Angela Zesiger have joined forces to start A&Z Lettuce Products, a processor of packaged shredded lettuce for institutional use. Zania has years of food processing experience, and Angela has extensive commercial food preparation experience. The process will consist of opening crates of lettuce and then sorting, washing, slicing, preserving, and finally packaging the prepared lettuce. Together, with help from vendors, they think they can adequately estimate demand, fixed costs, revenues, and variable cost per bag of lettuce. They think a largely manual process will have monthly fixed costs of $37,500 and variable costs of $1.75 per bag. A more mechanized process will have fixed costs of $175,000 per month with variable costs of $1.00 per bag. They expect to sell the shredded lettuce for $2.75 per bag.

a) The break-even quantity in units for the manual process = **37,500** bags (round your response to the nearest whole number).

b) The revenue for the manual process at the break-even quantity = **$103,125** (round your response to the nearest whole number).

c) The break-even quantity in units for the mechanized process = **42,857** bags (round your response to the nearest whole number).

d) The revenue for the mechanized process at the break-even quantity = **$117,857** (round your response to the nearest whole number).

e) For monthly sales of 60,000 bags, for the option with manual processing, A&Z Lettuce Products will have a profit of **$ [Blank]** (round your response to the nearest whole number and include a minus sign if the profit is negative).

*Note: Diagrams or additional data visualization elements were not included in the provided image.*
Transcribed Image Text:**Title: Break-Even Analysis for A&Z Lettuce Products** Zania Azlett and Angela Zesiger have joined forces to start A&Z Lettuce Products, a processor of packaged shredded lettuce for institutional use. Zania has years of food processing experience, and Angela has extensive commercial food preparation experience. The process will consist of opening crates of lettuce and then sorting, washing, slicing, preserving, and finally packaging the prepared lettuce. Together, with help from vendors, they think they can adequately estimate demand, fixed costs, revenues, and variable cost per bag of lettuce. They think a largely manual process will have monthly fixed costs of $37,500 and variable costs of $1.75 per bag. A more mechanized process will have fixed costs of $175,000 per month with variable costs of $1.00 per bag. They expect to sell the shredded lettuce for $2.75 per bag. a) The break-even quantity in units for the manual process = **37,500** bags (round your response to the nearest whole number). b) The revenue for the manual process at the break-even quantity = **$103,125** (round your response to the nearest whole number). c) The break-even quantity in units for the mechanized process = **42,857** bags (round your response to the nearest whole number). d) The revenue for the mechanized process at the break-even quantity = **$117,857** (round your response to the nearest whole number). e) For monthly sales of 60,000 bags, for the option with manual processing, A&Z Lettuce Products will have a profit of **$ [Blank]** (round your response to the nearest whole number and include a minus sign if the profit is negative). *Note: Diagrams or additional data visualization elements were not included in the provided image.*
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.