Excel template - Saved le Home Insert Data Review View Help Tell me what you want to do A = 29 General Calibri - 11 -A BIURA ill M Paste $ - % 9 682 Insert Delete For Conditional Format Formatting - as Table Tables M Chipboard Font Alignment Number Cells Determining the optimal Product Mix with One Constrained Resource Comfy Fit Company manufactures two types of university sweatshirts and information regarding the two sweatshirts are below. DATA Swoop Rufus - Unit contribution margins Minutes of machine time required to affix the logo $19 24 Regardless of type, each sweatshirt must be fed through a stitching machine to affix the appropriate university logo. 12 Number of machines leased by the company Number of hours each machine can operate per year 1100 14 Number of minutes per hour 15 Using formulas and cell references, perform the required analysis, and input your answers into the Amount column If no entry is required, enter 0. Transfer the numeric results for the green entry cells (B19:B20, B22:B23, 825) into Data template - saved x) Excel File Home RX Help Tell me what you want to do Insert Data Review View Colbri 1 A BIUROCA General = = $ - % -% Conditional Format Insert Delete Formatting as Tablet Clipboard Number Using formulas and cell references, perform the required analysis, and input your answers into the Amount column If no entry is required, enter 0. Transfer the numeric results for the green entry cells (B19.B20, B22:B23, B25) into 16 the appropriate fields in CNOWV2 for grading. Formulas 18 Required: 19 1. Contribution margin per hour of machine time - Swoop: Contribution margin per hour of machine time - Rufus: Amount $0.89 =87/88 $0.79 EC7/08 20 2. Number of Swoop sweatshirts produced for the optimal mix Number of Rufus sweatshirts produced for the optimal mix 00 46 =B13/08 22 23 24 25 3. Total contribution margin for the optimal mix $871 +823'07 Determining the optimal Product Mix with One Constrained Resource Comfy Fit Company manufactures two types of university sweatshirts, the Swoop and the Rufus, with unit contribution margins of $8 and $19, respectively. Regardless of type, each sweatshirt must be fed through a stitching machine to affix the appropriate university logo. The firm leases seven machines that each provides 1,100 hours of machine time per year. Each Swoop sweatshirt requires 9 minutes of machine time, and each Rufus sweatshirt requires 24 minutes of machine time. Assume that there are no other constraints. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet Required: 1. What is the contribution margin per hour of machine time for each type of sweatshirt? Do not round intermediate calculations. Round your answers to the nearest cent. Contribution Margin Swoop $ Open spreadsheet Required: 1. What is the contribution margin per hour of machine time for each type of sweatshirt? Do not round Intermediate calculations. Round your answers to the nearest cent. Contribution Margin Swoop $ Rufus $ 2. What is the optimal mix of sweatshirts? Do not round intermediate calculations. Round your answers to the nearest whole number. If an amount is zero, enter "0". Optimal Mix Swoop units Rufus 0 units 3. What is the total contribution margin earned for the optimal mix? Do not round intermediate calculations. Round your answer to the nearest dollar. $ Excel template - Saved le Home Insert Data Review View Help Tell me what you want to do A = 29 General Calibri - 11 -A BIURA ill M Paste $ - % 9 682 Insert Delete For Conditional Format Formatting - as Table Tables M Chipboard Font Alignment Number Cells Determining the optimal Product Mix with One Constrained Resource Comfy Fit Company manufactures two types of university sweatshirts and information regarding the two sweatshirts are below. DATA Swoop Rufus - Unit contribution margins Minutes of machine time required to affix the logo $19 24 Regardless of type, each sweatshirt must be fed through a stitching machine to affix the appropriate university logo. 12 Number of machines leased by the company Number of hours each machine can operate per year 1100 14 Number of minutes per hour 15 Using formulas and cell references, perform the required analysis, and input your answers into the Amount column If no entry is required, enter 0. Transfer the numeric results for the green entry cells (B19:B20, B22:B23, 825) into Data template - saved x) Excel File Home RX Help Tell me what you want to do Insert Data Review View Colbri 1 A BIUROCA General = = $ - % -% Conditional Format Insert Delete Formatting as Tablet Clipboard Number Using formulas and cell references, perform the required analysis, and input your answers into the Amount column If no entry is required, enter 0. Transfer the numeric results for the green entry cells (B19.B20, B22:B23, B25) into 16 the appropriate fields in CNOWV2 for grading. Formulas 18 Required: 19 1. Contribution margin per hour of machine time - Swoop: Contribution margin per hour of machine time - Rufus: Amount $0.89 =87/88 $0.79 EC7/08 20 2. Number of Swoop sweatshirts produced for the optimal mix Number of Rufus sweatshirts produced for the optimal mix 00 46 =B13/08 22 23 24 25 3. Total contribution margin for the optimal mix $871 +823'07 Determining the optimal Product Mix with One Constrained Resource Comfy Fit Company manufactures two types of university sweatshirts, the Swoop and the Rufus, with unit contribution margins of $8 and $19, respectively. Regardless of type, each sweatshirt must be fed through a stitching machine to affix the appropriate university logo. The firm leases seven machines that each provides 1,100 hours of machine time per year. Each Swoop sweatshirt requires 9 minutes of machine time, and each Rufus sweatshirt requires 24 minutes of machine time. Assume that there are no other constraints. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet Required: 1. What is the contribution margin per hour of machine time for each type of sweatshirt? Do not round intermediate calculations. Round your answers to the nearest cent. Contribution Margin Swoop $ Open spreadsheet Required: 1. What is the contribution margin per hour of machine time for each type of sweatshirt? Do not round Intermediate calculations. Round your answers to the nearest cent. Contribution Margin Swoop $ Rufus $ 2. What is the optimal mix of sweatshirts? Do not round intermediate calculations. Round your answers to the nearest whole number. If an amount is zero, enter "0". Optimal Mix Swoop units Rufus 0 units 3. What is the total contribution margin earned for the optimal mix? Do not round intermediate calculations. Round your answer to the nearest dollar. $
