Question: 2. On the spreadsheet found on that file, input formulas that will calculate the following: a. Total cost for each item b. Total retail for

2. On the spreadsheet found on that file, input

2. On the spreadsheet found on that file, input formulas that will calculate the following: a. Total cost for each item b. Total retail for each item c. Total cost of all items purchased d. Total retail of all items purchased e. Markup percentages for each item f. Cumulative markup percentage for all items purchased 3. Make the calculations listed above for problems that follow, and record your answers on the tables provided at the end of the assignment. 4. When you have completed the assignment, save the file as SPREADSHEET H_COPY, and close the file. PROBLEMS 1. Stock # 1234 1235 1236 1237 1238 Units Ordered 300 100 25 150 20 Unit Cost $1.23 $26.98 $99.00 $21.45 $82.45 Unit Retail $2.50 $55.99 $199.99 $39.99 $175.99 2. Stock # 1234 1235 1236 1237 1238 Units Ordered 88 10 14 24 15 Unit Cost $1.29 $25.40 $96.00 $20.00 $81.50 Unit Retail $2.50 $55.99 $199.99 $39.99 $175.99 3. Stock # 1234 1235 1236 1237 1238 Units Ordered 288 50 24 124 10 Unit Cost $1.40 $26.00 $99.99 $21.00 $82.00 Unit Retail $2.90 $56.00 $105.00 $45.00 $165.00 4. Stock # 1234 1235 1236 1237 1238 Units Ordered 300 90 10 210 30 Unit Cost $1.23 $26.98 $99.00 $21.45 $82.45 Unit Retail $2.99 $56.99 $199.99 $40.99 $176.99 5. Stock # 1234 1235 1236 1237 1238 Units Ordered 1,288 150 124 1,124 110 Unit Cost $11.23 $26.98 $99.00 $21.45 $82.45 Unit Retail $23.99 $57.99 $198.99 $45.99 $170.99

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Show all formulas 2. On the spreadsheet found on that file, input formulas that will calculate the following: a. Total cost for each item b. Total retail for each item c. Total cost of all items...

Complete a season six-month merchandising plan using last year's results. Use historical sales (LY) results and percentage increase in sales to project plans for sales by dollars for this year (TY)....

AutoSave OFT Case 8 Horniman StudyQs(1) - Compatibility Mode - Saved to my Mac References Mailings Review View Tell me Share ert Draw Design Layout Comments Calibri (Bo. 11 v AA Ao Ev==v= = - x x ADA...

Single plantwide factory overhead rate Bach Instruments Inc. makes three musical instruments: flutes, clarinets, and oboes. The budgeted factory overhead cost is $151,200.-Overheld is allocated to...

Hi there I need help answering ASSIGNMENT 1 ONLY by Friday afternoon. I have attached the study pack to help answer the question. Thanks! FIN4802 ASSIGNMENTS ASSIGNMENT 01 Due date: 13 May 2016...

May get help with requirement 1. The detail is in the document. Thanks Required: 1) Set up an professionally formatted Excel spreadsheet for the data provided and perform the following calculations...

forgot to add this in this is the beginning. Instructions: 1. Calculate your available open-to-buy dollars and insert it onto the assortment plan (cell B2). 2. Review all items listed on the Product...

Hercules Inc. manufactures elliptical exercise machines and treadmills. The products are produced in its Fabrication and Assembly production departments. In addition to production activities, several...

Given the following observations from a population, calculate the mean, the median, and themode. 150 257 55110 110 43 201125 55

What are the basic steps in the recording process?

10. (LO3) We discussed five international capital market relationships: relative PPP, IRP, UFR, UIP, and the generalized Fisher effect. Which of these would you expect to hold most closely? Which do...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...