Estimate the maximum possible daily profit, Macroeconomics

Assignment Help:

Shambles have selected the "Mythical Beasts" range and decided to concentrate on "Pegasus" and "Phoenix." They would now like to find the right mix of these two products in order to maximise profit. Each toy has to go through two processes during manufacture: sewing and stuffing.

Pegasus takes 30 minutes to sew whilst Phoenix takes 20 minutes; there are 10 hours (600 minutes) available for sewing each day.

Pegasus takes 20 minutes to stuff whilst Phoenix takes 25 minutes; there are 10 hours (600 minutes) available for stuffing each day.

Pegasus generates £4 profit per toy whilst Phoenix generates £5 profit per toy.

What is the maximum possible daily profit, and how many of each product should be produced in order to achieve this?

Use "Solver" in Microsoft Excel to solve this problem. Include:

a print-out of cell values
a print-out of cell formulae
a print-out of the Solver dialogue box with optimisation conditions and constraints
an Answer Report from Solve
a statement of the answer in words

 


Related Discussions:- Estimate the maximum possible daily profit

Nursing home has a book value, Beverly enterprises owns a nursing home that...

Beverly enterprises owns a nursing home that is currently earning $2.0 million in cash flow on an annual basis, but this amount is expected to drop in the future. The nursing home

Paper, Ask Jenny, your niece, is a smart high-school student who wants to m...

Ask Jenny, your niece, is a smart high-school student who wants to make smart choices for her future. Hearing of your course in Business Economics, she has emailed you asking for a

Willing to hold money, Was money a better store of value in the United Stat...

Was money a better store of value in the United States in the 1950s than it was in the 1970s? Why or why not? In which period would you have been willing to hold money? Which one w

Find the npv and the irr determine cash flows, The Research and Development...

The Research and Development Division of your company has just developed a new gaming system called the Zed Box.  The R&D Division spent $800,000 developing this product and the Ma

Fiscal Policy, What are the effects of the fiscal stimulus on the macroecon...

What are the effects of the fiscal stimulus on the macroeconomy

Trade-off proposals, While referring to the "EYE on YOUR LIFE" section on p...

While referring to the "EYE on YOUR LIFE" section on page 235 of the textbook, and the economic concepts you have accumulated during our course, consider the trade policies that se

Calculate percent removal pollutant and steady state, You are considering t...

You are considering three design alternatives for treating a pollutant in wastewater using a first-order process ( k = 1 min -1 ). The total flow is 10 million gallons per day (mg

Trade, What is the difference between heckscher_olin theory and comparative...

What is the difference between heckscher_olin theory and comparative theory

Write Your Message!

Captcha
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