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 keynesian model, Q. What is Keynesian model? Keynesian model is...

Q. What is Keynesian model? Keynesian model is slightly more complicated than the classic model and it is developed in four stages by analysing four separate models. Every mode

Analyse data using anova, A scientist postulates that grazing by gastropod ...

A scientist postulates that grazing by gastropod snails affects the settlement of Spirorbid worms in estuaries. She sets up a manipulative experiment to test this by using cages to

Analitical approch, what is analitical approch to macroeconomics

what is analitical approch to macroeconomics

Abnormal profits, explain the terms abnormal profits and normal profits

explain the terms abnormal profits and normal profits

Money, who are cheap money;gainers and losers

who are cheap money;gainers and losers

Develop the mrp planning schedule, Product A is an end item and is made fro...

Product A is an end item and is made from two units of B and four of C. B is made of three units of D and two of E. C is made of two units of F and two of E. A has a lead time o

Keynesian cross in an open economy, why does the price level not enter desi...

why does the price level not enter desire consumption, investment and net exports of the desired aggregate expenditure function in the keynesian cross model

Each good as a final good or intermediate good, Classify each good as a fin...

Classify each good as a final good or intermediate good. (briefly explain wach choice) 1. running shoes 2. cotton fibers 3. watches 4. textbooks 5. coal 6. sunscr

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