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)
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…
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 %
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
Consider the requirement that shopping malls need a license to remain open 24 hours, where these licenses are in fixed supply. These licenses are however freely tradable among actual and potential owners, and the industry is perfectly competitive. If the average 24-hour shopping mall’s annual revenue is $250,000, while the licenses may be leased at an annual fee of $100,000. Given this information, average variable cost for the industry would be $100,000. Is the preceding statement true or false?
Bigby Riggs sells high-end art frames that are ordered every Thursday to prepare for next week's demand. The most popular frame style is sold at $50 per unit and it costs Bigby $35 per piece. If too many art frames are ordered, Bigby incurs an inventory carrying cost of $2 per frame. If Bigby runs out of stock for the week, he forgoes the profits from missed sales. Bigby has the option to order 100, 150, or 200 art frames to meet next week's demand which can be either 100, 150, or 200 frames. Based on historical demand, Bigby has determined the following probability information: P(100) = 0.4, P(150) = 0.3, P(200) = 0.3 What is the Expected Monetary Value of your best alternative?
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) a) If we are going to use the EOQ inventory model, mention all the assumptions that are made to validate that model. b) How many pounds of type A material should Huda order (i.e. Q*) at a time if she wishes to minimize total inventory cost? c) How many orders per year would be placed? 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: Annual Ordering cost Annual hdding: Number of orders placed per…
A company that manufactures laser printers for computers has monthly fixed costs of 177000 and variable costs of 650 per unit produced. The company sells the printers for 1250 per unit. How many printers must be sold each month for the company to break even? please solve

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