2 3 4 5 6 7 8 9 10 11 12 13 14 Start Excel Download...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
2 3 4 5 6 7 8 9 10 11 12 13 14 Start Excel Download and open the file named EXP19 Excel Ch06 ML2 HW DeckBuilders.xlsx. Grader has automatically added your last name to the beginning of the filename Calculate total building expensive for model A in cell C16. Total expense is calculated by multiplying manufacturing cost (C4) and total contracts (C8) Then use the fill handle to copy the formula into cells D16 and E16 Calculate total profit for model A in cell C17 Total profit is calculated by multiplying profit marging (C6) and total contracts (C8). Then use the fill handle to copy the formula into cells D17 and E17 Create range names based on the values in the range C19 C20 based on the values in the range B19 B20 In cell C19 use the SUM function to calculate total building expenses. The total building expenses are the sum of the range C16 E16. In cell C20 use the SUM function to calculate total profits. The total profit is the sum of the range C17 E17 If not loaded, load the Solver add-in Set the objective cell to Max Net Profit (cell C21) Assign Total Contracts (range C8 E8) as the Changing Variables Cells Set a constraint to ensure contracts are whole numbers. Set a constraint to ensure the raw material used do not exceed inventory Set a constraint to ensure that the Total Contracts are greater or equal to the existing contracts Create an Answer Report to outline your findings Create a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side of both worksheets. Save and close Exp19_Excel Ch06_ML2_HW_DeckBuilders xlsx Exit Excel. Submit the file as directed. Total Points D 8 8 6 A 10 14 4 4 18 16 O 100 1 2 3 5 6 7 87 B 9 0 1 2 3. File 1 Paste Clipboard A Home Insert X (6 S Calibri BIU V B Indy Deck Builders Raw Material Wood Hardware Paint Model Manufacturing Cost Selling Price Profit Margin Existing Contracts Total Contracts Font Draw Page Layout Model Building Expense Total Profit Deck Builders Total Building Expense Total Profit Net Profit Y fx 555 $ $ AA == A- A S 566.25 $ $ 2,000.00 $ $ 1,433.75 $ 15 Existing Contracts Formulas A 45 0 D B B Datal Alignment 828.75 $ 3,500.00 $ 2,671.25 $ 55 0 Review View Wrap Text Merge & Center Cost Per Unit Units in Inventory Total Units Consumed $ 2.00 70000 20000 0.75 1.25 35000 E C C 1,258.75 5,000.00 3,741.25 75 0 0 S 0 0 F Help General $ % 98 98 Y 00 Number 15 Conditional Format as Cell Formatting Table Styles Styles Raw Material Required Per Model Wood Hardware Paint Raw Materials Consumed Wood Hardware Paint V H A A 200 55 100 000 B B 310 70 125 0 OOO 0 0 Insert Delete Format Cells + C 500 95 150 C 000 OFIM Σ K 2 3 4 5 6 7 8 9 10 11 12 13 14 Start Excel Download and open the file named EXP19 Excel Ch06 ML2 HW DeckBuilders.xlsx. Grader has automatically added your last name to the beginning of the filename Calculate total building expensive for model A in cell C16. Total expense is calculated by multiplying manufacturing cost (C4) and total contracts (C8) Then use the fill handle to copy the formula into cells D16 and E16 Calculate total profit for model A in cell C17 Total profit is calculated by multiplying profit marging (C6) and total contracts (C8). Then use the fill handle to copy the formula into cells D17 and E17 Create range names based on the values in the range C19 C20 based on the values in the range B19 B20 In cell C19 use the SUM function to calculate total building expenses. The total building expenses are the sum of the range C16 E16. In cell C20 use the SUM function to calculate total profits. The total profit is the sum of the range C17 E17 If not loaded, load the Solver add-in Set the objective cell to Max Net Profit (cell C21) Assign Total Contracts (range C8 E8) as the Changing Variables Cells Set a constraint to ensure contracts are whole numbers. Set a constraint to ensure the raw material used do not exceed inventory Set a constraint to ensure that the Total Contracts are greater or equal to the existing contracts Create an Answer Report to outline your findings Create a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side of both worksheets. Save and close Exp19_Excel Ch06_ML2_HW_DeckBuilders xlsx Exit Excel. Submit the file as directed. Total Points D 8 8 6 A 10 14 4 4 18 16 O 100 1 2 3 5 6 7 87 B 9 0 1 2 3. File 1 Paste Clipboard A Home Insert X (6 S Calibri BIU V B Indy Deck Builders Raw Material Wood Hardware Paint Model Manufacturing Cost Selling Price Profit Margin Existing Contracts Total Contracts Font Draw Page Layout Model Building Expense Total Profit Deck Builders Total Building Expense Total Profit Net Profit Y fx 555 $ $ AA == A- A S 566.25 $ $ 2,000.00 $ $ 1,433.75 $ 15 Existing Contracts Formulas A 45 0 D B B Datal Alignment 828.75 $ 3,500.00 $ 2,671.25 $ 55 0 Review View Wrap Text Merge & Center Cost Per Unit Units in Inventory Total Units Consumed $ 2.00 70000 20000 0.75 1.25 35000 E C C 1,258.75 5,000.00 3,741.25 75 0 0 S 0 0 F Help General $ % 98 98 Y 00 Number 15 Conditional Format as Cell Formatting Table Styles Styles Raw Material Required Per Model Wood Hardware Paint Raw Materials Consumed Wood Hardware Paint V H A A 200 55 100 000 B B 310 70 125 0 OOO 0 0 Insert Delete Format Cells + C 500 95 150 C 000 OFIM Σ K
Expert Answer:
Answer rating: 100% (QA)
Raw material consumed Raw material required Total contracts Total uniits consumed s... View the full answer
Related Book For
Posted Date:
Students also viewed these mathematics questions
-
As stated in Chapter 23, mammalian cells can become resistant to the lethal action of methotrexate by the selective survival of cells containing increases in dihydrofolate reductase gene copy number...
-
Suppose that we are a bank with $3,000 worth of deposits. We operate in an economy with a mandated reserve ratio of 12%. Suppose that the bank is keeping $450 in reserves currently, loaning out the...
-
Assign trucks to delivery routes so that total costs are minimized, given the cost data shown. What is the totalcost? E-7 5689 D-8 3454 E-09 8 0 53 B-5 4 3 2 5 A-4 6756 12345
-
Practice Problem 6: We-B-Busy, Inc. uses job costing and a predetermined overhead rate based on machine hours (MH). The firm estimated that it would use $240,000 of MOH and 7,500 MH this year. Data...
-
What factors are important in a DBMS software selection?
-
Contrast the roles of the management accountant and management in setting standard costs.
-
On page 718 is an ER diagram for the expenditure cycle. Required: a. List the entity database tables and describe which entities need representing from an AIS perspective. b. For each item identified...
-
The Houston Corporation acquires machinery from the South Company in exchange for a $20,000 non-interest-bearing, five-year note on June 30, 2006. The note is due on June 30, 2011. The machinery has...
-
Find a parabola with equation y-ax2 + bx + c that has slope 14 at x 1, slope -18 at x = -1, and passes through the point (2, 37). 2 y= 9x-4x+9 X Need Help? Read It
-
A mechanism for pushing small boxes from an assembly line onto a conveyor belt, repeated from Prob. 5/89, is shown with arm OD and crank CB in their vertical positions. For the configuration shown,...
-
Saathvik Limited is planning invest Rs. 200 Lakhs in a new project which will be financed by equity shares and term-loans in the ratio of 1:3. The existing capital structure of the company has the...
-
The information and communication component of internal control includes the accounting system. What other forms of communication are included?
-
How undercutting can be avoided in cams?
-
What is the auditor's overall objective in an audit of financial statements?
-
Why is the audit risk model not normally used in the evaluation of audit evidence?
-
What are the methods for reducing pressure angle of a cam?
-
PART 4 (20 minutes) Baher Clothing Store is preparing its budget for the coming year. Inventory on August 31 was $176,200. Company's policy that inventory is maintained at 200% of the following...
-
Use a calculator to evaluate the expression. Round your result to the nearest thousandth. V (32 + #)
-
Explain the term project champion and list some ways to keep a champion involved with the project.
-
Three recent college graduates have formed a partnership and have opened an advertising firm. Their first project consists of activities listed in the following table. a. Draw the precedence diagram....
-
How accurate is your local five-day weather forecast? Support your answer with actual data.
-
Construct a combined common-size and common-base year balance sheet for 2007. What will be the common-base year value for the 2007 net fixed assets? a. 0.89 b. 0.92 c. 1.12 d. 1.32 AHS INC. 2007...
-
What will be the value of AHS' equity multiplier during 2007? a. 0.44 b. 0.56 c. 1.78 d. 1.82 AHS INC. 2007 Income Statement (S in millions) Net sales S 9625 Cost of goods sold 5225 Depreciation 1890...
-
What will be the value of AHS' current ratio during 2007? a. 1.14 b. 1.42 c. 1.49 d. 1.53 AHS INC. 2007 Income Statement (S in millions) Net sales S 9625 Cost of goods sold 5225 Depreciation 1890...
Study smarter with the SolutionInn App