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

Value to change expect the market, You just inherited a house with a market...

You just inherited a house with a market value of $300,000, and do not expect the market value to change. Each year, you will pay $1,000 for utilities and $3,000 in taxes. You can

What are the responsibilities of central banks, What are the Responsibiliti...

What are the Responsibilities of central banks Responsibilities include providing banking services to commercial banks and the government and regulating financial markets and i

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

Develop what you believe is a terrific idea, To develop what you believe is...

To develop what you believe is a terrific idea for a video game, you lease 50,000 square feet in an office building from Commercial Property, LLC, under a written five-year lease.

Investment demand of the as-ad model, Q. Investment demand of the AS-AD mod...

Q. Investment demand of the AS-AD model? Investment demand. As long as we keep nominal interest rate (and thus real interest rates) constant, there is no reason for demand for

Question one hw, A small country can import a good at a world price of 10 p...

A small country can import a good at a world price of 10 per unit. The domestic supply curve of the good is S = 20 + 10P The demand curve is D = 400 – 5P In addition, each unit of

Labour market, use a graph of the classical labour market to illustrate the...

use a graph of the classical labour market to illustrate the effects of a real wage existing in the market that is lower thhan the equilibrium real wage

National income, effects of tax increase on the gross domestic product

effects of tax increase on the gross domestic product

Classical model, determination of interest rate in classical model

determination of interest rate in classical model

Explain about penicillic acid, Q. Explain about Penicillic Acid? This m...

Q. Explain about Penicillic Acid? This mycotoxin has biological properties similar to patulin. It is produced by a large number of fungi, including many Penicillia as well as m

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