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

What causes a demand curve to shift, What causes a demand curve to shift? ...

What causes a demand curve to shift? a. Changes into the Prices of Related Goods Substitutes Complements b. Changes into Income Normal Goods Inferio

#title.williams managerial discretion model, The different between williams...

The different between williams managerial discretion model and baumol''s sales maximization model

Economies as a scope, If there are economies of scope and if the price for ...

If there are economies of scope and if the price for each product equals marginal cost, is it possible for a firm to cover all its costs? If the firm's average cost of production d

What are the comparative benefits, What are the comparative benefit The...

What are the comparative benefit The idea of comparative benefit defines that a nation must specialise in the industries in which it has a comparative advantage. Comparative be

Percentage did the price level, By what percentage did the price level, as ...

By what percentage did the price level, as measured by this index, rise between 1984 and 2005?

Percentage must this cost be reduced, Cd players are produced on an automat...

Cd players are produced on an automated assembly line process. The standard cost of CD players is 150.00 per unit. The sales price is $300.00 per unit. To achieve a 10 percent mult

Long-run labor demand, Long-Run Labor Demand: Graph an increase in the...

Long-Run Labor Demand: Graph an increase in the wage when only labor is a 'normal' input to production. Graph an increase in the wage when both inputs are 'normal'

Unemployment rate for each country, The following Table B presents the 2010...

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 lab

What are the costs of economic growth, What are the costs of economic growt...

What are the costs of economic growth? Economic growth can result also into: • Increases within pollution noise and congestion • Unnecessary depletion of non-renewable r

Explain the problem with IS-LM model, Q. Explain the problem with IS-LM mod...

Q. Explain the problem with IS-LM model? The starting point of AS-AD model is an assumption in IS-LM model (and in the cross model) that limits its usefulness. This is an assum

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