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

Average price of a textbook, The demand for textbooks is Q=200-P+25U-50Pbee...

The demand for textbooks is Q=200-P+25U-50Pbeer. Assume that the unemployment rate U is 8 and the price of beer P beer is $2. When the average price of a textbook is P=$100, the el

Gross domestic savings, Gross Domestic Savings  Income not devoted to c...

Gross Domestic Savings  Income not devoted to current consumption is saved. In an economy during a particular year some units will consume less than their income while some wil

Determine the problems there with consumer price index, Determine the Probl...

Determine the Problems evolved with Consumer Price Index To illustrate problems involved in calculating CPI we consider MP3 players. If you measure average price of MP3 players

Macroeconomics, Suppose that several months of data showed the CPI increasi...

Suppose that several months of data showed the CPI increasing at a 4.5% annual rate due largely to increases in the price of energy and food related commodities following several y

Problem sets #2, I want to know price and estimate time on this assignment....

I want to know price and estimate time on this assignment.

World bank, explain the functions and role of the world bank

explain the functions and role of the world bank

Regional trading arrangements, Regional Trading Arrangements: You have...

Regional Trading Arrangements: You have seen in earlier Units that India has been playing an active role in WTO discussions. While Hong Kong WTO Ministerial has saved and kept

Show the ad curve over time, Q. Show the AD curve over time? With infla...

Q. Show the AD curve over time? With inflation, AD curve will no longer be stable over time. In its place, it will glide upwards or downwards at a rate determined by growth rat

Unemployment, explain the phillips curve the relationship of inflation and ...

explain the phillips curve the relationship of inflation and unemployment

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