Bexter Labs produces three products: A, B, and C. Bexter can sell up to 2000 units of Product A, up to 3000 units of Product B, and up to 5000 units of Product C. Each unit of Product C uses two units of A and three units of B and incurs $7 in processing costs. Products A and B are produced from either raw material 1 or raw material 2. It costs $9 to purchase and process one unit of raw materials. Each processed unit of raw material 1 yields two units of A and four units of B. It cost $5 to purchase and process Raw Material 2. Each processed unit of raw material 2 yields one unit of A and three units of B. The unit prices are: A,7; B,9; and C,6. The average quality level of the units sold must be at least 8. Determine how to maximize Bexter's profit.

Hints: Units of A and B available for sale is the units and A and B produced from raw materials minus what was used to produce C.

Set up quality constraint as total actual quality versus total required quality.

O P w - 10 10:18 PM 2/14/2020 211 Search the Web or type S B Sign in 7 - 0 X AutoSave Of H File Home : Sp20-3560-ETO6-Ch04-2-Shell - Excel Page Layout Formulas Data Review S earch View Help Insert Draw Share Comments Calibri 11 A === General E E 47 0 A A Wrap Text 3 Merge & Center - Paste LG BI U D $ -% -8 Insert Delete Format Ideas Conditional Format as Formatting Table Styles Cell Styles Sort & Find & Filter Select Editing Clipboard Font Alignment Number Cells Ideas A1 X Spring 2020 - MGT 3560: HW06-Ch04-2 Name: Cole Baxter (UTC ID: tgx696) A E F G H A 5 #1. Problem #94 (40 points) 6 Purchasing/processing cost of raw material 7 Cost per unit Raw material 1 Raw material 2 I J K L M N O P Caution: Do not alter the structure of this Excel file like adding/deleting columns/rows, mov cells, or renaming sheet names. Use the specified output cell range. You may chan slightly to accommodate proper formatting, but changing the widths in a significa Not following these instructions can result in serious loss of points. Product Product B Product C Selling price of products Quality level of products Average quality level required All cells in all sheets must be properly formatted. These include aligning contents, number format and decimal places for numerical contents, use of bolding, italics, appropriate fashion so that the readability of the content is enhanced. Processing one unit of raw materials into products Per unit input Output of products per unit raw material Raw material 1 Raw material 2 Yield of product A per unit of the raw material Yield of product B per unit of the raw material A required B required A and B used to produce one unit of C Processing cost for C Raw material 1 Raw material 2 24 25 Raw material nurchased and processed Sheet1 Sheet2 Sheet3 + @ J - - O P w - 10 10:18 PM 2/14/2020 211 Search the Web or type S B Sign in 7 - 0 X AutoSave Of H File Home : Sp20-3560-ETO6-Ch04-2-Shell - Excel Page Layout Formulas Data Review S earch View Help Insert Draw Comments Calibri 11 A === General A A 5 Wrap Text 3 Merge & Center - Share E Er 48 0 Insert Delete Format n elemente P2 Fconditional Formule Paste BI U D $ - % 9 | 188 -98 $ -% -8 Insert Delete Format Conditional Format as Formatting Table Styles Cell Styles Filter Select Editing Clipboard Font Alignment Number Cells Ideas X for Spring 2020 - MGT 3560: HW06-Ch04-2 Name: Cole Baxter (UTC ID: tgx696) B E F G H I J K L M N O P Raw material 1 Raw material 2 Raw material purchased and processed Product A Product B A and B produced from raw materials Product C produced Product A Product B Constraints on A and B for processing C Units of A and B required Product A Product B Product C Total sales Hints: Units of A and B available for sale is the units and A and B produced from raw mate Units of A, B, and C available for sale Maximum sales Quality constraint Actual quality Required quality Set up quality constraint as total actual quality versus total required quality. 42 43 Sales revenue Raw material cost Sheet1 Sheet2 Sheet3 @ J - - P w 10:19 PM 2/14/2020 TU.. Search the Web or type S B Sign in 7 - 0 X AutoSave Of H File Home : Sp20-3560-ETO6-Ch04-2-Shell - Excel Page Layout Formulas Data Review S earch View Help Insert Draw Comments Calibri 11 A === General A A Wrap Text 3 Merge & Center - P2 $ - % 9 | 48 95 Fconditional Format zas o E Insert Delete Format Share Er 48 0 5 set de France Ideas Paste BI U D $ -% -8 Insert Delete Format Ideas Conditional Format as Formatting Table Styles Cell Styles Sort & Find & Filter Select Editing Clipboard Font Alignment Number Cells Ideas X for Spring 2020 - MGT 3560: HW06-Ch04-2 Name: Cole Baxter (UTC ID: tgx696) F G H I J K L M N O P A Maximum sales Quality constraint Actual quality Required quality Set up quality constraint as total actual quality versus total required quality. Sales revenue Raw material cost Cost of processing C Profit Answer key: 50250 Sheet1 Sheet2 Sheet3 + D -_