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 is real gross domestic product, What is Real GDP To be able to ma...

What is Real GDP To be able to make reasonable comparisons of GDP over time, we must adjust for inflation. For instance, if prices are doubled over 1 year then GDP would doubl

Production, mention and explain four factors that determine the volume of p...

mention and explain four factors that determine the volume of production.

Exogenous variable change, Market questions come in two types: Type 1: y...

Market questions come in two types: Type 1: you are given the exogenous variable change and you must shift the correct curve in the right direction and then determine the new pr

How many pounds of potatoes will she purchase, Potatoes cost Janice $1 per ...

Potatoes cost Janice $1 per pound, and she has $5.00 that she could possibly spend on potatoes or other items. If she feels that the first pound of potatoes is worth $1.50, the sec

Model Questions Required, 1) Assume that the production function for New Ze...

1) Assume that the production function for New Zealand is given by Y = AK0.57L0.43, where Y is real GDP (in 2000 constant dollars), K is real capital stock, L is labour. The parame

Circular flow of income in a closed economy, circular flow of income in a s...

circular flow of income in a single sector,two sector,three sector and four sector

Analitical approch, what is analitical approch to macroeconomics

what is analitical approch to macroeconomics

The difference among a floating and managed exchange rate, Explain the diff...

Explain the difference among a floating and managed exchange rate. The key distinction here is that a floating exchange rate is set by market forces, i.e. supply and demand. A

Online homework, I want you to do online homework as you did before on apl...

I want you to do online homework as you did before on aplia.com All questions are 10. They are in Aggregate Demand and Aggregate Supply The deadline within 24 hours. Please do

What factors find out the price elasticity of demand, What factors find out...

What factors find out the price elasticity of demand? Factors which determine the price elasticity of demand are: a. Whether close substitutes are accessible b. Whether t

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