Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2 On the SalesData worksheet, in cell F4, create a formula that will perform a calculation that multiplies the Unit Price by the sum

image
image

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

Step by Step Solution

3.49 Rating (156 Votes )

There are 3 Steps involved in it

Step: 1

Answer FORMULA IFSUMC4D4E4B40SUMC4D4E4B4Discontinue IFc... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Supply Chain Focused Manufacturing Planning and Control

Authors: W. C. Benton

1st edition

2901133586714 , 1133586716, 978-1133586715

More Books

Students also viewed these Electrical Engineering questions