A brewery produces regular beer and a lower-carbohydrate "light" beer. Steady customers of the brewery buy 10 units of regular beer and 15 unitsof light beer monthly. While setting up the brewery to produce the beers, the management decides to produce extra beer, beyond that needed tosatisfy customers. The cost per unit of regular beer is $29,000 and the cost per unit of light beer is $50,000. Every unit of regular beer brings in$200,000 in revenue, while every unit of light beer brings in $500,000 in revenue. The brewery needs at least $15,000,000 in revenue, and hasdetermined that the total demand will be at least 48 units of beer. Complete parts (a) and (b)BELED(a) How much of each type of beer should be made so as to minimize total production costs?units of light beer should be made, for a minimum total cost of $units of regular beer and(Type integers or decimals.)(b) Suppose the minimum revenue is increased to $15,700,000. Use shadow costs to calculate the total production cost.The shadow cost of production is $ The increased minimum revenue corresponds to a total production cost of $(Type integers or decimals.)

Let the number of regular beer units produced be R and light beer units be L. Minimum Regular beer…

Answered: A brewery produces regular beer and a…

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...

See similar textbooks

Similar questions

A toy manufacturer uses 45,980 rubber wheels per year for its popular dump truck series. The firm makes its own wheels, which it can produce at a rate of 900 per day. The toy trucks are assembled uniformly over the entire year. Carrying cost is per wheel per year. Setup cost for a production run is. The firm operates 242 days per year. Determine the following: a. Optimal run size (Round your answer to a whole number, following normal rules of rounding.) b. Use your final answer from part a to determine minimum total annual cost for carrying and setup. (Round your answer to a whole number.) c. Cycle time for the optimal run size (Round your answer to two decimal points.)
Lisa makes two sorts of jewelry-Type A and Type B. Type A requires 2.5 hours of curving and 10 hours of assembly time.On the other hand, Type B requires 3 hours of curving and 5 hours of assembly time. Lisa can sell Type A for $120 and Type B for $195. Given that Lisa has only 500 hours of curving 500 hours of assembly time. How many of each type of Jewelry Lisa should make to maximize revenue? (Possible Answer $19,500)
XYZ company has determined that the annual demand for type A material is 20,000 pounds. Salma, who works in her brother's factory, is in charge of purchasing. She estimates that it costs $15 every time an order is placed. This cost includes her wages, the cost of the forms used in placing the order, and so on. Furthermore, she estimates that the cost of carrying one pound in inventory for a year is 0.05 $. Assume that the demand is constant throughout the year. (Note: $ is a dollar sign) d) What would the annual ordering cost be? e) What would the average inventory be? f) What would the annual holding cost be? See equations below if needed: Number of orders placed per year Annual Ordering cost Annual hdding= Annual demand Number of units in each order Average inventory Ordering cost per order Ordering cost per order (Carrying cost per unit = b.c
Ethan Manufacturing Incorporated produces floor mats for automobiles. The owner, Joseph Ethan, has asked you to assist in estimating maintenance costs. Together, you and Joseph determine that the single best cost driver for maintenance costs is machine hours. These data are from the previous fiscal year for maintenance costs and machine hours: Month Maintenance Costs Machine Hours $ 2,650 1 2 9 10 11 12 2,810 2,960 3,070 3,150 3,120 3,060 2,900 2,670 2,270 2,280 2,500 1,740 1,820 1,900 1,920 1,950 1,930 1,910 1,890 1,750 1,150 1,350 1,640 Required: 1. What is the cost equation for maintenance costs using the high-low method? 2. Calculate the mean absolute percentage error (MAPE) for the cost equation you developed in requirement 1. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Calculate the mean absolute percentage error (MAPE) for the cost equation you developed in requirement 1. (Input your final answer as a percentage rounded to 1 decimal…
A manufacturer that produces 100 different products is considering building a new warehouse because there is no room in raw material and product warehouses. Because although some products are more than in the warehouse, some demands that come due to the fact that the ban products are not enough in the warehouse are avoided. For this reason, it plans not to miss any demand by producing and storing enough of all its products, and of course it is considering building a new and larger warehouse to store more products. What can you suggest to this company, taking into account what is described in the course, describe your proposal in maximum detail with the concepts described in the course, as applicable activities.
A large corporation maintains a fleet of three 30-passenger corporate jets that provide daily scheduled service between Detroit & several cities that are home to its production facilities. The jets are used strictly for business travel. The executives bood reservations thru a centralized transportation office. Because of the limited number of seats available, the planes almost always fly full. Excess demand for seats is assigned by executive rank within the firm. The executive's budget is charged for the flight at the end of the month. The charge is based on the jet's total operating expenses during the month (to include fuel, pilot's salary & fringes, maintenance, licensing & landing fees, and 1/2 of the annual accounting depreciation) divided by the actual passenger miles logged in the month. This rate per passenger is multiplied by each passenger's mileage flown in the month.A. Describe the formula being used to calculate the cost per passenger mile flown.B. As passenger…
In the spreadsheet model shown below, an analyst makes the following data entries. Cell ВЗ В4 В5 B6 Value 113,000 90,000 119,000 99,000 A 1 Revenue 2 Month Revenue Change (%) n/a =(B4-B3)/B3 =(B5-B4)/B4 =(B6-B5)/B5 3 January 4 February 5 March 6 April What values will be shown in the following cells? (Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.) Cell Value С4 % C5 C6 %
please help solve. very confused on how to go about this problem. thanks
A manufacturing company faces an uncertain demand for its product at an average of 10,000 units per year. Selling price of the product is IDR. 1.500.000,-. The cost of holding per unit per year is estimated at IDR 350.000,-. Profit of the product is IDR. 300,000,- per unit. If the company could not meet the demand, then the profit will be lost. Ordering lead time is approximately 7 days, and the demand during lead time follows a uniform distribution of 30 to 200 units. a.Determine order quantity and reorder points to minimise the total cost. b. Determine the review period and maximum inventory to minimise the total cost C. Calculate the total cost for item a and b based on the your iteration on the data
help me with parts a,,b,c. Previous experts provided the wrong answer for me and please draw the graph so i can get a clear image.
We run a fresh produce stand at farmer’s market where we sell avocados and artichokes. Each morning, a supplier drops off bags of these products. We can buy up to 200 bags of avocados and up to 175 bags of artichokes each morning. We resell the bags to customers throughout the day. The contribution margin of avocados is $15/bag; the contribution margin of artichokes is $20/bag. We sell at least twice as many bags of avocados as we do artichokes. We have found that our normal daily demand is between 140 and 350 total bags what are the constaints
A building has an NOI of $130,000 and is being valued with a cap rate of 4%. Using the income approach, what is the value of the building? $4,130,000 $1,300,000 $3,250,000 $2,450,000

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

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

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

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…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS