Determine the number of grape and the number of apple pies

Assignment Help Operation Management
Reference no: EM13221309

A retired couple supplements 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 $1.50 to the grocer, and the grape pies are sold for $1.20. The couple is able to sell all of the pies they produce owing to their high quality. They use fresh ingredients. Flour and sugar are purchased once each month. For the month of September, they have 1,200 cups of sugar and 2,100 cups of flour. Each apple pie requires 11/2 cups of sugar 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 make an apple pie in six minutes and a grape pie in three minutes. They plan to work no more than 60 hours.

b. Determine the amounts of sugar, flour, and time that will be unused.

How do you answer this question in Excel?

I have the answers to the problem but need some help setting the problem up in excel.

 

Reference no: EM13221309

Previous Q& A

  Determine the end-of-year balances for unrestricted net

The University of Danville is a private not-for-profit university that starts the current year with $700,000 in net assets: $400,000 unrestricted, $200,000 temporarily restricted, and $100,000 permanently restricted.

  Explain the innovative process that must take place

explain the innovative process that must take place for successful integration of innovation. Recommend how an industry leader should search, select, implement, acquire, execute, launch, and sustain an innovative offering that is appropriate for t..

  Depict the chemical equation for all the reactions

Write the chemical equation for all the reactions both SN1 and SN2 involving primary and secondary substrates b) Rank the primary halide in order of increasing reactivity toward SN2

  Compute the budgeted factory overhead rate

Compute the budgeted factory overhead rate

  Evaluate the social responsibility approach

Select an organization that you are interested in researching. Evaluate the social responsibility approach of that company with regard to one of the following social issues: a) environmental protection, b) worker health and safety, or c) product s..

  Which training method best addresses the adult learner

In your opinion, which training method best addresses the adult learner's need for participation and interaction? why?

  What is the elasticity of demand for the square shreddies

You estimate the demand function for the square shreddies to be Qs=80-20Ps-6Pm+10Pd, where Pm is the price of milk, Ps is the price of the square shreddies, and Pd is the price of the diamond shreddies. what is the elasticity of demand for the squ..

  Describe a project selection process

Please describe a project selection process from either the literature or an organization of your choice. If it's from the literature, please submit the article; if it's an organization, please include the website. Include a figure showing the p..

  Develop a warehousing operational strategy

How should the chief warehouse manager of PCL approach problem and develop a warehousing operational strategy to overcome the problem and fulfill the redefined objectives of the firm.

  Explain complexities that would arise under new scenarios

Assume that Microsoft is considering a merger. The possible merger faces some threats and that the industry desides on self-expansion as an alternative strategy, describe the additional complexities that would arise under this new scenario of expa..

Reviews

Write a Review

 

Similar Q& A

  This should be an enjoyable activity and help you realize

This should be an enjoyable activity and help you realize the wide number of factors in the retail store that are used to motivate your buying behavior.

  Illustrate what kind of behaviour controls best facilite

Illustrate what kind of behaviour controls will best facilitate positive interactions both within the teams also among the teams.

  Describes the situation of industry is facing

The initial investment to acquire also install the equipment is $256,000. The variable price to produce each unit will be $15 also the selling price for the finished product will be $30. Which of the subsequent best describes the situation of indu..

  What were the critical drivers of starbucks success

What were the critical drivers of Starbucks success

  Elucidate basic dispatch rules fall short in this situation

Some cases may be life-threatening, while others are inconsequential. Elucidate how the basic dispatch rules fall short in this situation?

  Illustrate what is nominal percent return

Illustrate what is nominal percent return. Explain how would inflation alter those returns also illustrate what would real rate of return be.

  Has the new math program been effective

Construct a control chart for test errors and set the control limits to contain 99.73% of the random variations in test scores. What does the chart tell you? Has the new math program been effective?

  Define lex talionis

What term is used by the Federal Government to denote ultra high security prisons? What type of prisons house the most serious offenders and are characterized by double and triple security patterns? Define lex talionis.

  Categorize the following causes of complaints into a cause

Categorize the following causes of complaints into a cause-and-effect diagram: tools, scheduling, defective parts, training, billing system, performance measures, diagnostic equipment, and communications.

  Find total annual cost of managing the inventory

Joe Henry's machine shop uses 2500 brackets during the course of a year. these brackets are purchased from a supplier 90 miles away.

  Despite the lack of authority

Superior Company draws a check payable to Ted. Uri makes a note payable to Vital Finance Corporation.

  Describe the standard rules of overtime pay

What are the standard rules of overtime pay? Provide examples of why it is not always simple to administer.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd