Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PLEASE SHOW EXCEL FORMULAS!!! PLEASE SHOW EXCEL FORMULAS!! Item STD-001 STD-002 STD-003 STD 004 STD-OOS ST-006 TD STD-008 STD-009 PER-001 FER 003 PER-003 IPER-204 PER

PLEASE SHOW EXCEL FORMULAS!!!image text in transcribedPLEASE SHOW EXCEL FORMULAS!!

Item STD-001 STD-002 STD-003 STD 004 STD-OOS ST-006 TD STD-008 STD-009 PER-001 FER 003 PER-003 IPER-204 PER OOS PER OOG PER-007 Tatal Sales Jan $ Sales 5 64,184 $ 17,675 $ 41,670 $ 31,860 $ 336 $ 39,984 $ 624 $ 90,860 $ 76,833 $ $ $ 10,688 $ 3,040 $ 42,500 $ 48,884 25,164 $ 10.549 $ 505,190 Jan Unit Sales Feb $ Sales Feb Unit Sales Mar $ Sales Mar Unit Sales April Sales 294 $ 99,722 997 S 15.594 69 $ 10,939.40 101 $ 27,125 155 $ 83,650 478 $ 92.592.50 453 $ 20,700 231 $ 17,640 196 $ 19,205.00 135 $ 4,956 21 $ 73.632 312 $ 97,350.CO 2 S 69,384 413 S 57,120 340 S 83,160.00 1965 R0,172 393 94.048 4123 52,734,00 16 17,628 452 $ 19.198 492 $ 5,019.30 413 $ 6.820 31 S 21.120 96 S ve 30 29,765.CO 394 5 26,715 137 S 13,650 70 S 74,645.00 9 $ 14,658 385 3,344 BRS R.8 19.80 157 $ 27,008 422 $ S 31.808 497 $ 1,971.20 95 $ 13,899 434 S 128 $ 0,230.40 250 R3,90 494 $ 77,690 457 $ 5,732.00 404 $ 32,186 265 $ 46,827 387 $ 54,038,60 466 $ 8,424 156 S 19.764 366 $ 25,185.60 137 $ 11,704 152 $ 36,036 468 5 33.710.60 3,532 $ 535.170 4,540 $ 601,239 4,732 $ 602,103.40 April Unit Sales May $ Sales 44 $ 35,301.20 481 $ 42,735.00 1945 31,878.00 375 $ 97,859.20 450 $ 46,015.20 235$ 3 72,930.00 117 $ 17,074,20 123 $ 1. 73,094.00 348 $ 27,670.50 211 13,919.40 28 $ 985.60 127 13.491.00 36 $ 63,393.00 406 $ 20,753.60 424 $ 14.612.40 398 $ 21,005,60 4,047 $ 592,718.50 May Unit Sales Jun $ Sales 142 $ 30,329.20 222 $ 16,170 00 322 $ 41,481.00 377 $127,469.60 249 $ 26,056.80 325 $ 14,586 00 398 $ 15,572.70 3025116 SNG OR 129 $ 12,44100 333 $ 4,154 20 14 $ 10,203 00 383 $ 11,616.00 339 S 54 978 on 156 $ 62,423.90 246 $ 118.80 248 $ 39,300 80 4.185 S588 786 ON June Unit Sales QZ YTD $ Sales Q2 YTD Unit Sales 122 S 246.OGS 1,058 84S 279,948 1,521 419 $ 172,565 1,R25 491 $ 433, 131 1,711 141 S 282,072 1,595 65S 344454 1.526 363 $ 75.10 1,838 493s 339,53 1.449 5815 231,953 1,136 219 $ 50,247 1,246 145 $ 82,569 1,273 330 IS 48,384 1,423 2945 329273 1,870 469 $ 265,123 2.088 2 215 93,269 1.66O 4645 152,306 1,867 4,149 $ 3.425 204 25,185 342 What was the per unitsale price increase or decrease ofitem STD-003 from March April what was the average sales price per unit ofitem STD-004 through 2 YTD? what wasthewerage sales price per unit ofitem PER-DOS through Q2 YTD? Q2 YTD Sales Sales Reports Provided by Joan Unit Sales Provided by James + Ready E P + 100%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Accounting Principles

Authors: Jerry J. Weygandt, Paul D. Kimmel, Donald E. Kieso

9th Edition

978-0470317549, 9780470387085, 047031754X, 470387084, 978-0470533475

More Books

Students also viewed these Accounting questions

Question

Answered: 1 week ago

Answered: 1 week ago