Question: 1. what is the maximum profit? (the NUMERICAL value not the steps for excel solver) 2. formulate as a spreadsheet model and attatch yours so

1. what is the maximum profit? (the NUMERICAL value not the steps for excel solver)

2. formulate as a spreadsheet model and attatch yours so i can check to see if mine is correct.

- do NOT give me the steps to organizing the spreadsheet and excel solver. i do NOT want that. if you can not provide me with this request then do not answer my question. please allow someone who will give me the numerical value to solve it for me then. Please provide me with a visual.

- please provide me with the answer to both photos (one is different than the other even though they look like the same question)

please please please im begging you provide me with the numerical answer of the maximim profit

1. what is the maximum profit? (the NUMERICAL value not the steps

for excel solver) 2. formulate as a spreadsheet model and attatch yours

Franklin clothing company manufactures dress, shorts and pants. They rent dress machinery for $200/ week, shorts machinery for $150/ week and pants machinery for $100/ week. Requirements data is as follows: Franklin's goal is to maximize profit. Formulate as IP Spreadsheet model and solve to answer how many of each type they should produce to maximize profits. Franklin clothing company manufactures dress, shorts nd pants. They rent aress machinery for $200/ week, shorts machinery for $150/ week and pants machinery for $100/ week. Requirements data is as follows: - If Shorts machinery is rented, then at least 40 shorts should be produced per week. Franklin's goal is to maximize profit. Formulate as IP Spreadsheet model and solve to answer how many of each type they should produce to maximize profits

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

uke engineering produces batteries for a major car-maker . Juke'smonthly cost structured is shown in the table below . Assume that the firm's average variable costs of production remain constant at...

1: Directions: 1) Read the entire selection below 2) Answer the questionssee additional notes below.... Selection: Bradley's Food Stand John Bradley is a senior at Tech, and he's investigating...

Subject: Management Science Methods Please note that you are expected to ONLY formulate this problems a,b,c (algebraically) Do not worry about solving the models for now I need answer for d,e,f,g too...

Using the template provided please! Part 2: Create Data Tibl These two variables should be numbers that you enter into the spreadsheet. When it is complete you should be able to change either of the...

Let me know if there is anything else i need to provide. On Monday, Sepcontroller, the salate rations um-sized private ther, and Blue Bell Canners Case On Monday, September 13, 2018. Mr. Mitchell...

For each question, your mathematical model and answers to each individual part should be typed in Microsoft Word . Also, for each question, state your model by clearly defining your decision...

2.6.* This is your lucky day. You have just won a $20,000 prize. You are setting aside $8,000 for taxes and partying expenses, but you have decided to invest the other $12,000. Upon hearing this...

3.6-3. The following data are provided for a linear programming problem where the objective is to minimize the cost of conducting two non-negative activities in order to achieve three benefits that...

2.6.* This is your lucky day. You have just won a $20,000 prize. You are setting aside $8,000 for taxes and partying expenses, but you have decided to invest the other $12,000. Upon hearing this...

Consider the following problem. Maximize Z 2x1 5x2, subject to x1 2x2 10 (resource 1) x1 3x2 12 (resource 2) and x1 0, x2 0, where Z measures the profit in dollars from the two activities. While...

3.4-1. Joyce and Marvin run a day care for preschoolers. They are trying to decide what to feed the children for unches. They would like to keep their costs down, but also need to meet the...

An investment with initial value zero can go up or down $10,000 per month with equal likelihood. (a) What is probability that the investment will reach $1,000,000 without reaching $250,000? (b) What...

Refer to the data in P6. In P6, Teague Company engaged in the following transactions in October 2014: Oct. 7 Sold merchandise on credit to Mel Forde, terms n/30, FOB shipping point, $12,000 (cost,...

perdisco assignment 10 Classify the following statements regarding the binomial option pricing model as being either true or false: True False a) In order to calculate the option price, it is...

Free cash flow valuation You are evaluating the potential purchase of a small business with no debt or preferred stock that is currently generating $ 4 2 , 7 0 0 of free cash flow ( F C F 0 = $ 4 2 ,...