User Account

All Pages

Find the optimal daily production combination of desks

Assignment Help Basic Statistics
Reference no: EM131554899

A furniture manufacturer makes a mix of desks (D) and chairs (C). Each desk uses two units of wood, and each chair uses four units of wood. Each desk generates a profit of $55, and each chair generates $35 in profit. Production facilities are setup in such a way that the number of chairs produced must be exactly 1.25 times the number of desks. The plant capacity is 40 pieces of furniture a day. There are 140 units of wood available per day. The furniture manufacturer wishes to find the optimal daily production combination of desks and chairs in order to maximize profit in a given day.

a. State the Objective function mathematically.

b. State the constraints mathematically.

c. Setup the model in Excel and use Solver to determine the optimized solution.

d. How many desks should be produced?

e. How many chairs should be produced?

f. What is the overall daily profit?

Note that Excel formulas and Solver settings need to be correct in Microsoft Excel in order to have an opportunity for full credit on this problem (even if the correct answers are shown). In addition, the Instructor will be running Solver on your spreadsheets to ensure the optimal solution is obtained, based on your model. Note: there is no need to specify optimized results to be integer values.

Reference no: EM131554899

Questions Cloud

The firm net working capital changed : The firm's net working capital changed from $28 at the beginning of the year to $30 at the end, depreciation was $52, and net fixed assets have gone up by $107.
Mahalanobis distance to determine the outliers : How do you use Mahalanobis distance to determine the outliers? I have the distances from SPSS. How do I use the Chi square table to figure this out?
Does not take accounts for flotation costs : The company’s capital structure is 30 percent debt and 70 percent equity. Assume company use retained earnings, and does not take accounts for flotation costs.
Mean and standard deviation of the average loss : What are the mean and standard deviation of the average loss for 14 policies? (Round your standard deviation to two decimal places.)
Find the optimal daily production combination of desks : The furniture manufacturer wishes to find the optimal daily production combination of desks and chairs in order to maximize profit in a given day.
Identify a professional nursing organization you belong to : Contact your local State Representative to discuss recent and upcoming health policy legislation. State who you contacted and why. What was the result?
What is the probability that the sample mean : What is the probability that the sample mean would differ from the true mean by less than 1.1 dollars if a sample of 385-gallon pails is randomly selected?
Identify at least two articles from the proquest database : identify at least two articles from the ProQuest database that highlight and discuss two of the biggest challenges facing financial managers today.
Who is your audience for the everyday argument : Who is your audience for the everyday argument? How do you appeal to the audience's emotions

Reviews

Write a Review

Basic Statistics Questions & Answers

  Set up the anova table and test at the 5 level of

given the following data drawn from three normal populationstreatment1 2 38 11 1616 13 2013 12 1514 15 139 1011set up

  Confidence interval for the population of all americans

If appropriate, find a 90% confidence interval for the population of all Americans who consider that the amount of federal income tax they pay as too high.

  Data on the number of occurrences per time period and

data on the number of occurrences per time period and observed frequencies follow. compute the value of the test

  If you flip a coin three times the possible outcomes are

q1. for the following questions would the following be considered significant if its probability is less than or equal

  On a certain examination the average score is 53 and the

on a certain examination the average score is 53 and the standard deviation is 6. find a range of values within which

  Enough memory to open the data set

The data is posted on Blackboard. Download the data lfs4.dta on your personal computer. This data is from the Labour Force Survey 2003. In STATA, add enough memory to open the data set (Set memory 300) and open the data file. Refer to the Record L..

  A higher score represents higher levels of anxiety

on a certain anxiety questionnaire the population is known to have a mean of 12 and a standard deviation of 2.3. a

  Is it reasonable to conclude that the mean weekly salary of

the milton area chamber of commerce wanted to know whether the mean weekly salary of nurses was larger than that of

  Find oucomes in sample space-probability distribution table

Determine the oucomes in the sample space, and construct a probability distribution table. Find the expected value of the following game.

  Relationship between the amount of fire damage

A fire insurance wants to examine the relationship between the amount of fire damage in major residential fires to the distance between the burning house and the nearest fire station. A sample of 15 recent fires in a particular city was taken.

  Confidence interval for the depth of the reservoir

Historical records indicate the mean depth at this location for the previous 10 years is 78.4 feet. Is there any evidence to suggest this population mean has changed?

  Estimate fixed cost element using regression analysis

Discuss a hospitals total maintenance costs, and use regression analysis to estimate the fixed cost element of maintenance and the variable cost associated with the number of patient-days.

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd