Give typed full explanation b. Determine the amounts of sugar, flour, and time that will be unused (Leave no cells blank - be certain to enter "0" whereverrequired. Round your intermediate calculations and final answers to the nearest whole number.)Answer is complete but not entirely correct.SugarFlourTime2292701,272cupscupsminutes A retired couple supplement their income by making fruit pies, which they sell to a local grocery store. During the month of September.they produce apple and grape pies. The apple pies are sold for $3.00 to the grocer, and the grape pies are sold for $2.70. The coupleis able to sell all of the pies they produce owing to their high quality. They use fresh ingredients. Flour and sugar are purchased onceeach month. For the month of September, they have 1,200 cups of sugar and 2,100 cups of flour. Each apple pie requires 1½ cups ofsugar and 3 cups of flour, and each grape pie requires 2 cups of sugar and 3 cups of flour.a. Determine the number of grape and the number of apple pies that will maximize revenues if the couple working together can makean apple pie in 6 minutes and a grape pie in 3 minutes. They plan to work no more than 60 hours (Round your answers to nearestwhole number.)Answer is complete but not entirely correct.AppleGrapeRevenue1664441,697PiesPies

Let the number of Apple Pies made be A and Grape Pies made be G.Total Revenue = Selling Price per…

Answered: A retired couple supplement their…

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 purchasing agent for a particular type of silicon wafer used in the production ofsemiconductors must decide among three sources. Source A will sell the siliconwafers for $2.50 per wafer, independently of the number of wafers ordered. Source Bwill sell the wafers for $2.40 each but will not consider an order for fewer than3,000 wafers, and Source C will sell the wafers for $2.30 each but will not acceptan order for fewer than 4,000 wafers. Assume an order setup cost of $100 and anannual requirement of 20,000 wafers. Assume a 20 percent annual interest rate forholding cost calculations.a. Which source should be used, and what is the size of the standing order?
A purchasing agent for a particular type of silicon wafer used in the production ofsemiconductors must decide among three sources. Source A will sell the siliconwafers for $2.50 per wafer, independently of the number of wafers ordered. Source Bwill sell the wafers for $2.40 each but will not consider an order for fewer than3,000 wafers, and Source C will sell the wafers for $2.30 each but will not acceptan order for fewer than 4,000 wafers. Assume an order setup cost of $100 and anannual requirement of 20,000 wafers. Assume a 20 percent annual interest rate forholding cost calculations.b. What is the optimal value of the holding and setup costs for wafers when theoptimal source is used?
A home improvement store sells hydrangea plants during the spring planting season. The hydrangeas cost the store $15 per unit, and sell to customers for $45, but any leftovers at the end of the season are salvaged to a local landscaper for $7/unit. A competitor has advertised that it guarantees 99% of customers find the product they’re looking for in stock. The competitor’s posted price for hydrangeas is $50, and they salvage to the same local landscaper for $7/ hydrangea plant. If the competitor’s advertised service level is correct for hydrangeas and they follow an optimal stocking policy, what does it imply their cost per hydrangea is?
In the following scenario, what will your stockout costs be if you have 200 hammers in stock and you have orders of 80, 60, 50, 30, 120 You are a wholesaler selling hammers. You have a carrying cost for each hammer left in inventory of $.30 per unit, ordering cost of $60 per order placed, and a stockout cost of $30 per customer who is not fully satisfied and $3 per hammer for any orders not fulfilled (lost sales). Orders placed arrive in the sixth week after the week in which the order is placed. Smallest orders are filled first. $480 $1,080 $660 $450 $300
Any Company buys and resells a wide range of personal care products. Their ongoing challenges, like many of their competitors include shipping time for purchases, optimizing use of their storage space, and shipping time for sales to their customers. The company’s control over shipping time for purchases is limited. Their choice of suppliers has more impact on shipping time than any encouragement they can offer to those suppliers. Any Company uses multiple warehouses. Some are owned by the company, others are leased. The company uses contract shippers, FedEx/UPS, and the US Postal Service. Your task is to identify at least 4 KPIs you think will be relevant for Any Company to understand and improve their inventory management. Identify the data necessary for your KPIs as specifically as possible. You may use any KPIs we have mentioned in class or from the labs. Feel free to use others or to create your own. Your response does not need to include a description of graphs you might…
Sampaguita Company makes corsages that it sells through salespeople on the streets. Each sells for P2 and has variable production costs of P0.80. The salespeople receive a P0.50 commission on each corsage they sell, and the company must spend P0.05 to get rid of each unsold corsage. The corsages last for only one week and cannot be carried in inventory.The manager of the firm had estimated demand per week and associated probabilities as follows:Demand Probability100,000 0.20120,000 0.20140,000 0.30160,000 0.30 The optimal weekly production of the corsage is? Please show solution.
A firm is faced with the attractive situation in which it canobtain immediate delivery of an item it stocks for retailsale. The firm has therefore not bothered to order the item in any systematic way. However, recently profits have beensqueezed due to increasing competitive pressures, and thefirm has retained a management consultant to study itsinventory management. The consultant has determined thatthe various costs associated with making an order for theitem stocked are approximately $70 per order. She has alsodetermined that the costs of carrying the item in inventoryamount to approximately $27 per unit per year (primarilydirect storage costs and forgone profit on investment ininventory). Demand for the item is reasonably constantover time, and the forecast is for 16,500 units per year.When an order is placed for the item, the entire order isimmediately delivered to the firm by the supplier. The firm operates 6 days a week plus a few Sundays, or approxi-mately 320 days per year.…
Annie bought one dozen smartphones for 200,000 pesos with a discount of 5%. She sold half dozen at a price of 18,000 pesos per unit. However, a new model of smartphone became available in the market, so she sold the remaining half dozen at 12,000 pesos each unit. What was her profit or loss? Compute the following requirements: a. Gross profit rate b. Operating profit margin rate c. Net profit margin rate d. Return on investment
As a potential owner of a club known as Club Salida, you are interested in determining the necessary volume of sales in dollars to reach the breakeven next year. You decided to break down the club's sales into. four categories, where beer is the first. Your estimate of the sale of beer is that it will serve 30,000 servings. The selling price per unit will average $ 1.50; its cost is $ .75. The second category is food, of which you expect sell 10,000 units with an average unit price of $ 10.00 and a cost of $ 5.00. The third category is desserts and wine, of which you also hope to sell 10,000 units, but with an average unit price of $ 2.50 and a cost of $ 1.00. The last category is inexpensive lunches and sandwiches, of which you expect sell a total of 20,000 units with an average price of $ 6.75 and a cost per unit of $ 3.25. Your fixed costs (i.e. rent, utilities, etc.) are $ 1,800 a month plus $ 2,000 a month for entertainment. a) What is your breakeven point in dollars per month? b)…
Margo is a homeowner. Her mortgage principal and interest cost her $780 a month. Her insurance is $1,560 annually, and her property taxes are $5,100 annually. How much is her monthly payment, including PITI? $1.335 $1,557 $910 $1,205
Glams Touch is a budding cosmetics family business in Sekondi. The owners, Baaba Benson and Bernard Benson, must ensure that they judiciously use the store space available. They have never kept detailed inventory or sales records. They immediately place new items on the shelves as soon as shipment of goods arrives.Invoices from suppliers are only kept for tax purposes. During sales, they record the items numbers and the total amount received at the cash register. The owners use their own judgment in identifying items that need to be reordered. Baaba and Bernard rely on their own judgment in deciding the cosmetics that need to be restocked.Analyse the business implication of this situation. In your view, how could information systems be utilized to assist the Bensons manage Glams Touch. Enumerate some data that should be captured by the systems and what information outputs are to be churned out from the system.
As part of a campaign to promote its annual clearance sale, Excelsior Company decided to buy television advertising time on Station KAOS. Excelsior's television advertising budget is $111,000. Morning time costs $3000/min, afternoon time costs $1000/min, and evening (prime) time costs $12,000/min. Because of previous commitments, KAOS cannot offer Excelsior more than 6 min of prime time or more than a total of 25 min of advertising time over the 2 weeks in which the commercials are to be run. KAOS estimates that morning commercials are seen by 200,000 people, afternoon commercials are seen by 100,000 people, and evening commercials are seen by 600,000 people. How much morning, afternoon, and evening advertising time should Excelsior buy to maximize exposure of its commercials? morning min afternoon min evening min

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