Question 10 of 19 | 0.0 Points | 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. Upload your prediction model here. I'll refer to this file to provide partial credit or corroborate your work for the answers below. Click "Browse" to locate your file and then click "Upload" to upload your file. (Maximum file size: 20MB) File: Processing..... |
Question 11 of 19 | 4.0 Points | 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 12 of 19 | 12.0 Points | 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 13 of 19 | 0.0 Points | 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. Unload your linear optimization model here. Click "Browse" to locate your file and then click "Upload" to upload your file. (Maximum file size: 20MB) File: Processing..... |
Question 14 of 19 | 8.0 Points | 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 15 of 19 | 4.0 Points | 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.) |