subject
Business, 11.12.2019 23:31 saucybby

Imelda manages a shoe factory that makes two types of shoes: casual shoes and dress shoes. the factory can make a total of 1,000 pairs of shoes per day. on any given day, it cannot make more than 800 casual pairs of shoes. each pair of casual shoes needs 2 units of labor, while each pair of dress shoes needs 3 units of labor. the factory has 2,400 units of labor available daily. each pair of casual shoes earns a profit of $15, while each pair of dress shoes earns a profit of $20. how many pairs of each type should the factory make each day?
specify the decision variables.

specify the objective. this must be based on the inputs specified in the problem, the decision variables specified in (a), and/or intermediate variables specified in (c) below.

specify the constraints. these must be based on the input numbers specified in the problem, the decision variables specified in (a), and/or intermediate variables that you chose to specify.

build a model in excel where you can specify values for the input variables and see the effects on the constraints and objective. note that in order to receive credit, your spreadsheet must be sufficiently annotated so that it is readable. fit it to one page; if necessary, use landscape orientation to print and title it exhibit 1.

ensure that exhibit 1 is well edited and appropriately formatted, which includes showing formulas and including row and column headings.

to show formulas you can either go to the formula tab in excel and find "show formulas" from the "formula auditing" section or use the short cut key: ctrl + ` (note the grave accent key). you may need to resize some of the columns to maximize the readability.

to include row and column headings, there are multiple approaches. if you are using print screen to capture a picture of your model - then the column and row headings are there. if you are printing your model to a printer or a file, then you need to go to the "page layout" tab, there under the "sheet options" section you will find a check box for "print" under "headings". make sure to select to print the headings.

using your model, is it feasible to produce 500 pairs of casual shoes and 500 pairs of dress shoes? if no, why not? if yes, how do you read that from your model?

according to excel solver, what is the optimal production schedule?

ansver
Answers: 3

Another question on Business

question
Business, 22.06.2019 02:30
Question 1 which of the following tasks use your roommate as a resource? choose all answers which apply. take order wash the mixer’s bowl and mix the dough spoon cookies onto the tray unload the cookies from the oven pack the cookies 1 points question 2 which of the following tasks use the tray(s) as a resource? choose all answers which apply. take order wash the mixer’s bowl and mix the dough bake the cookies cool the cookies accept payment 1 points question 3 determine the task time for the following tasks. fill integer numbers into the blank (e.g., 5 rather than 5.0) wash and mixing the dough: minute(s)/order spoon cookies onto the tray: minute(s)/order set up timer: minute(s)/order bake: minute(s)/order cool the cookies: minute(s)/order pack the cookies: minute(s)/order accept payment: minute(s)/order 2 points question 4 q4: determine the cycle time for the following resources. fill integer numbers into the blank (e.g., 5 rather than 5.0) kristen (you): minute(s) roommate: minute(s) oven: minute(s) 2 points question 5 what is the capacity rate (in orders/hour) of the roommate? 1 points question 6 what is the capacity rate (in orders/hour) of the whole process? 2 points question 7 how long (in minutes) it takes to process the first order?
Answers: 3
question
Business, 22.06.2019 11:00
Companies hd and ld are both profitable, and they have the same total assets (ta), total invested capital, sales (s), return on assets (roa), and profit margin (pm). both firms finance using only debt and common equity. however, company hd has the higher total debt to total capital ratio. which of the following statements is correct? a) company hd has a higher assets turnover than company ld. b) company hd has a higher return on equity than company ld. c) none of the other statements are correct because the information provided on the question is not enough. d) company hd has lower total assets turnover than company ld. e) company hd has a lower operating income (ebit) than company ld
Answers: 2
question
Business, 22.06.2019 11:10
The prebisch–singer hypothesis concludes that: a. technology lowers the cost of manufactured products, so developing countries should see an increase in their terms of trade. b. developing countries experience a long-run decline in their terms of trade, as the demand for primary products in higher-income countries declines relative to their demand for manufactured goods. c. because of unfair trading practices, labor in developing countries is exploited. d. opec has been responsible for a slowdown in the world's standard of living.
Answers: 3
question
Business, 22.06.2019 13:50
The state troopers in one state have a motto, “nine you’re fine; ten you’re mine,” which is the standard that they use for pulling over speeders on the state highways. in other words, if the posted speed limit is 55 mph, drivers can drive at a rate up to 64 mph without fear of getting a ticket. which of the following best describes the ethical culture in the state? a. the troopers are following a standard of positive law. b. the troopers are following a normative standard. c. the troopers are following a headline test. d. the troopers are following the blanchard/peale standard.
Answers: 1
You know the right answer?
Imelda manages a shoe factory that makes two types of shoes: casual shoes and dress shoes. the fact...
Questions
question
Mathematics, 07.04.2021 21:40
question
Mathematics, 07.04.2021 21:40
question
Mathematics, 07.04.2021 21:40
Questions on the website: 13722361