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

Trade cycle, discus the various measures that may be taken by a firm to cou...

discus the various measures that may be taken by a firm to counteract the evil effect of a trade cycle

Appropriate experimental design, An ecologist has been reading the literatu...

An ecologist has been reading the literature on the subject of factors affecting growth and metamorphosis of tadpoles in ponds. Some frog species (e.g. Hyla gratiosa) reproduce in

Analyse and contrast the macroeconomic behaviour, Collecteconomic data for ...

Collecteconomic data for three countries: Australia, China and Greece.The data is toobtainedfrom official sources as time series forthe key macroeconomic variables. These arereal G

Agency mortgage-backed securities, This release also states that the Federa...

This release also states that the Federal Reserve is in the process of purchasing $1.25 trillion of agency mortgage-backed securities and about $175 billion of agency debt. Additio

Consumer price index, (Consumer Price Index)Given the following data, what ...

(Consumer Price Index)Given the following data, what was the value of the consumer price index in the base year? Calculate the annual rate of consumer price inflation in 2013 in ea

Calculate constant vector, A particle at position I with velocity i has a...

A particle at position I with velocity i has acceleration w given by i = w x ( w x i ) where ? is a constant vector. Show by using the vector triple product and calcula

Online test, I would like to know if you guys take up online tests?

I would like to know if you guys take up online tests?

Discuss about real verses nominal gross domestic product, Discuss about rea...

Discuss about real verses nominal gross domestic product. Real verses Nominal Gross Domestic Product: Real Gross Domestic Product: the value of the concluding goods and se

The crowding out effect, what goals and policies are being discused to addr...

what goals and policies are being discused to address the crowding out effect?

Trade between the two countries, Given the above trade between the two coun...

Given the above trade between the two countries, explain the trade effects on product prices, and factor incomes. Why do these effects occur?

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