A furniture company produces two types of desks, standard and deluxe. Their production requires three main resources: pine and oak wood, and labor.

	Standard	Deluxe
Board feet of pine	70	60
Board feet of oak		18
Hours for labor	10	15

Per week the company has 5,000 board feet of pine, 750 board feet of oak and 800 hours of labor available. Standard desks net profit is $220 and deluxe desks net profit is $340. The company is currently producing 27 standard desks and 35 deluxe desks.

Question 1

Develop a spreadsheet model to predict their weekly net profit as well as their usage of the three resources. Use appropriate formatting to clearly organize your spreadsheet model.

Accepted characters: numbers, decimal point markers (period or comma), sign indicators (-), spaces (e.g., as thousands separator, 5 000), "E" or "e" (used in scientific notation). NOTE: For scientific notation, a period MUST be used as the decimal point marker. Complex numbers should be in the form (a + bi) where "a" and "b" need to have explicitly stated values. For example: {1+1i} is valid whereas {1+i} is not. {0+9i} is valid whereas {9i} is not. Their current weekly profit is $ . (Round to two decimal places.)

Question 2

Accepted characters: numbers, decimal point markers (period or comma), sign indicators (-), spaces (e.g., as thousands separator, 5 000), "E" or "e" (used in scientific notation). NOTE: For scientific notation, a period MUST be used as the decimal point marker. Complex numbers should be in the form (a + bi) where "a" and "b" need to have explicitly stated values. For example: {1+1i} is valid whereas {1+i} is not. {0+9i} is valid whereas {9i} is not. Their current production uses ..........board feet of pine, ...........board fee of oak and ...........hours of labor. (Round all your answers to two decimal places.)

Question 3

The manager is not satisfied with their current net profit and would like to improve the company bottom line. Use linear optimization to determine how many standard desks and deluxe desks they need to produce on average (do not round them) per week in order to maximize weekly net profit.

Accepted characters: numbers, decimal point markers (period or comma), sign indicators (-), spaces (e.g., as thousands separator, 5 000), "E" or "e" (used in scientific notation). NOTE: For scientific notation, a period MUST be used as the decimal point marker. Complex numbers should be in the form (a + bi) where "a" and "b" need to have explicitly stated values. For example: {1+1i} is valid whereas {1+i} is not. {0+9i} is valid whereas {9i} is not. What is the optimal production of standard and deluxe desks to maximize total profit? (Round answers to two decimal places.) Standard desks = Deluxe desks =

Question 4

Accepted characters: numbers, decimal point markers (period or comma), sign indicators (-), spaces (e.g., as thousands separator, 5 000), "E" or "e" (used in scientific notation). NOTE: For scientific notation, a period MUST be used as the decimal point marker. Complex numbers should be in the form (a + bi) where "a" and "b" need to have explicitly stated values. For example: {1+1i} is valid whereas {1+i} is not. {0+9i} is valid whereas {9i} is not.

What is the maximum total? (Round to two decimal places