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

Explain why quantitative measures, Suppose a company is considering two inv...

Suppose a company is considering two investment projects. Both projects require an upfront expenditure of $30 million. The company estimates that the cost of capital is 10% and tha

Explain the labor market in the cross model, Q. Explain the labor market in...

Q. Explain the labor market in the cross model? In cross model, both P and W are exogenous andconstant. Hence real wage is constant and it is not essentially equal to the equil

Oil revenue on agricultural productivity, please,how do i relate keynesian ...

please,how do i relate keynesian theories on fiscal policy to the topic"impact of oil revenue on agricultural productivity?

Number of gallons of pain, The number of gallons of paint that Home Depot s...

The number of gallons of paint that Home Depot sells in a given day is normally distributed with a mean of 150 gallons and a standard deviation of 35 gallons (I realize that the di

Rent control agency of new york city, The rent control agency of New York C...

The rent control agency of New York City has found that market demand is QD=100-5P With quantity measured in tens of though sands of apartments and price, the monthly rental rate,

Overall effect of a change in real wages, Q. Overall effect of a change in ...

Q. Overall effect of a change in real wages? The supply of labor The supply of labour L S is assumed to be positively related to the real wage W/P

Payment toward its bank loan, During the year, Calabash Clinic made a $50,0...

During the year, Calabash Clinic made a $50,000 cash payment toward its bank loan which it had previously recorded; $40,000 was for principal, and $10,000 was to pay the full amoun

Classical model, using a graph of the classical labour market,illustrate th...

using a graph of the classical labour market,illustrate the effects of a real wage existing in the market that is lower than the equilibrium real wage.what will eventually happen i

How much money can banks create, Q. How much money can banks create? Do...

Q. How much money can banks create? Does that mean that banks can create an unlimited amount of money? No the answer is no - it would require them to lend an unlimited amount o

Define the tools of competitive market, Define the tools of Competitive mar...

Define the tools of Competitive market. Competitive market: The supply and demand model a. The demand curve b. The supply curve c. Factors which cause the demand cu

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