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

Incentives, Incentives Incentives designed to increase effort, reward e...

Incentives Incentives designed to increase effort, reward enterprise and encourage saving and investment include: an emphasis on the effect of a reduction in the margi

Upper bound of the confidence interval, A stock investor would like to have...

A stock investor would like to have an idea concerning the average return of stocks that are traded on a certain exchange. In a sample of 99 stocks, the average return was 9 percen

Determine about the expected inflation, Determine about the Expected inflat...

Determine about the Expected inflation Note that it is changes in prices during 2008 which matter for the high real interest rate (the time period when your deposit is earning

Quantity of twinkies demanded increases, Suppose the price of Twinkies decr...

Suppose the price of Twinkies decreases from $1.45 to $1.25 and, as a result, the quantity of Twinkies demanded increases from 2,000 to 2,200. Using the midpoint method, the price

What are the two types of money, What are the Two types of money In mos...

What are the Two types of money In most countries, one can identify two "types of money": Currency and coins Bank deposits Total value of all the money in a

Determine the output level-wholesale price, Assume an industry with one ups...

Assume an industry with one upstream and one downstream monopoly. The upstream monopoly produces Q , which is sold solely to the downstream monopoly. The downstream monopoly faces

Labor force participation rate, The following Table B presents the 2010 pop...

The following Table B presents the 2010 population, employment, and unemployment data among working age persons for several countries. a. Calculate the number of people in the l

Montary policy, Examine the efficiency of quanttitative credit control inst...

Examine the efficiency of quanttitative credit control instrument

Classical model of the labor market, Q. Classical model of the labor market...

Q. Classical model of the labor market? We begin by explaining the classical model of the labor market.  The demand for labor L D is assumed to be inversely re

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