2 On the SalesData worksheet, in cell F4, create a formula that will perform a calculation...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
2 On the SalesData worksheet, in cell F4, create a formula that will perform a calculation that multiplies the Unit Price by the sum of products sold for January, February, and March. If a product has not sold any units over the past three months, display Discontinue. If the project has sold units, display the results of the Unit Price multiplied by the sum of the products sold for January, February, and March. Copy the formula and then paste it in cells F5, F7:F9, F11:F12, F14:F15, and F17:F18. Resize the column as needed. 3 Product 4 64GB Hard Drive 5 128 GB Hard Drive 6 7 2GB Flash Drive 8 4GB Flash Drive 9 8GB Flash Drive 10 11 15" Monitor 12 18" Monitor 13 14 Keyboard 15 Ergo Keyboard 16 17 8GB RAM 18 16GB RAM 19 20 21 22 23 24 Totals by Item 25 Hard Drives 26 Flash Drives 27 Monitors 28 Keyboard 29 RAM 20 Unit Price $ 150.00 $ 249.00 B 8.00 $ $ 10.00 $ 15.00 $ 75.00 $ 100.00 is s $ 20.00 35.00 $ $ 150.00 $ 200.00 Monthly Snapshot Goal January 50 75 52 55 12 Actual Monthly Sales 12 7 20 18 5 2 13 D 3 2 February March 11 6 12 20 4 6 11 5 3 E Outcome 12 8 13 19 5 5 12 4 5 F Total H Product of the Month 75 Goal Product 2 On the SalesData worksheet, in cell F4, create a formula that will perform a calculation that multiplies the Unit Price by the sum of products sold for January, February, and March. If a product has not sold any units over the past three months, display Discontinue. If the project has sold units, display the results of the Unit Price multiplied by the sum of the products sold for January, February, and March. Copy the formula and then paste it in cells F5, F7:F9, F11:F12, F14:F15, and F17:F18. Resize the column as needed. 3 Product 4 64GB Hard Drive 5 128 GB Hard Drive 6 7 2GB Flash Drive 8 4GB Flash Drive 9 8GB Flash Drive 10 11 15" Monitor 12 18" Monitor 13 14 Keyboard 15 Ergo Keyboard 16 17 8GB RAM 18 16GB RAM 19 20 21 22 23 24 Totals by Item 25 Hard Drives 26 Flash Drives 27 Monitors 28 Keyboard 29 RAM 20 Unit Price $ 150.00 $ 249.00 B 8.00 $ $ 10.00 $ 15.00 $ 75.00 $ 100.00 is s $ 20.00 35.00 $ $ 150.00 $ 200.00 Monthly Snapshot Goal January 50 75 52 55 12 Actual Monthly Sales 12 7 20 18 5 2 13 D 3 2 February March 11 6 12 20 4 6 11 5 3 E Outcome 12 8 13 19 5 5 12 4 5 F Total H Product of the Month 75 Goal Product
Expert Answer:
Answer rating: 100% (QA)
Answer FORMULA IFSUMC4D4E4B40SUMC4D4E4B4Discontinue IFc... View the full answer
Related Book For
Supply Chain Focused Manufacturing Planning and Control
ISBN: 978-1133586715
1st edition
Authors: W. C. Benton
Posted Date:
Students also viewed these electrical engineering questions
-
20 21 22 23 24 11 14 15 7 8 9 10 13 4 6 2 3 5 ABC Co. manufactures widgets and has the following operating information for the past year: A A 12 B B Product Line Product Line Budgeted Unit Sales...
-
Flash Manufacturing manufactures 16 GB flash drives (jump drives). Price and cost data for a relevant range extending to 200,000 units per month are as follows: Sales price Per-unit (current monthly...
-
Write a formula that will convert the volume given in 1,000s into a volume given in 100s. Use the left side of the equation to indicate in which cell to store the formula. a. Intel Corp b. Yahoo! Inc...
-
Turtle Creek Partnership had the following revenues, expenses, gains, losses, and distributions Sales revenue Long-term capital gains Cost of goods sold Depreciation-MACRS $ 59,000 $ 3,300) $...
-
Explain why the cost of capital for a firm is equal to the expected rate of return to the investors in the firm.
-
What are some of the legal and ethical issues involved in collecting competitor intelligence in the following situations? a. Hotel A sends an employee posing as a potential client to Hotel B to find...
-
Which one of the below assertions is inaccurate concerning statistical sampling? (a) Statistical sampling involves additional costs of training auditors (b) Statistical sampling requires designing...
-
Relevant Costing, Cost-Based Pricing, Cost Behavior, and Net Present Value Analysis for NoFat The purpose of this integrated exercise is to demonstrate how a special sales-relevant decision analysis...
-
I am struggling with this question and could use a good explanation to support your answer. An investment project has annual cash in?ows of $4,1??, $3,955, $4,058, and $3,192 for the next four...
-
Cullumber Warehouse distributes hardback books to retail stores and extends credit terms of 4/10, n/30 to all of its customers. During the month of June, the following merchandising transactions...
-
The driving force for blood flow is a(n) O osmotic O pressure O gravity volume gradient.
-
The cost of the machine is $12,123. The CCA rate is 27%. After 8 years, the machine is sold for $2,177. If it is the only asset in the asset class and the tax rate is 37%, what is the TRTL? (Assume...
-
Milani, Incorporated, acquired 1 0 percent of Seida Corporation on January 1 , 2 0 2 3 , for $ 2 0 0 , 0 0 0 and appropriately accounted for the investment using the fair - value method. On January 1...
-
Knudsen Corporation was organized on January 1, 2021. During its first year, the corporation issued 2,000 shares of $50 par value preferred stock and 100,000 shares of $10 par value common stock. At...
-
S&J Lawn Service Company maintains its books on a cash basis. However, the company recently borrowed $ 2 1 0 , 0 0 0 from a local bank, and the bank requires S&J to provide annual financial...
-
Fore Farms reported a pretax operating loss of $ 2 9 2 million for financial reporting purposes in 2 0 2 4 . Contributing to the loss were ( a ) a penalty of $ 4 million assessed by the Environmental...
-
Oregon Forest Products will acquire new equipment that falls under the five-year MACRS category. The cost is $440,000. If the equipment is purchased, the following earnings before depreciation and...
-
Discuss the concept of the looking-glass self. how do you think others perceive you? do you think most people perceive you correctly?
-
Write a brief memo to your immediate manager discussing why the study of supply chain-focused manufacturing planning and control is important in today's competitive manufacturing environment.
-
The demand for refurbished cell phones is experiencing a decline. The company wants to monitor cell phone demand closely. The trend-adjusted exponential smoothing method is used with = 0.1 and =...
-
Consider the following demand and lead time data for Carnival Campers, Inc. DEMAND PER DAY PROBABILITY MANUFACTURING LEAD TIME (IN DAYS) PROBABILITY 1 0.4 2 0.3 2 0.6 3 0.7 a. Calculate...
-
In the discussion at the beginning of this chapter, do you think the motivations for holding cash are reasonable?
-
Solicitous Bank offers your firm an 8 percent discount interest loan for up to \($3\) million, and in addition requires you to maintain a 6 percent compensating balance against the amount borrowed....
-
Formulate complete PDE problems (specify the equation, space domain, time interval, and boundary and initial conditions) for the following model situations. a) Conduction heat transfer occurs in a...
Study smarter with the SolutionInn App