Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

3. Assume that you are a retailer and you sold the items below. Prepare an invoice using Excel. 2 dozens 10 pairs 12 pieces T-shirts

image text in transcribed

image text in transcribed

3. Assume that you are a retailer and you sold the items below. Prepare an invoice using Excel. 2 dozens 10 pairs 12 pieces T-shirts Shoes bags 250.00.pc. 850.00/pair 200.00/pc 4. Use Excel to compute for the net invoice price of the following merchandise: Item Stainless steel dishwasher 6.2 cu. ft. refrigerator 24 cu. ft. French door refrigerator List Price 3,750.00 42,957.00 96,148.00 Trade Discount 10% 10% and 5% 5% and 5% 5. A meat vendor decided to give a 10% discount on all her merchandise. Use Excel to compute the total net selling price of her inventory. Quantity 50 kilograms 50 kilograms 50 kilograms 50 kilograms 20 kilograms 20 kilograms Item Pork lion Choice beef cuts Beef ribs Pork ribs Pork bones Beef bones Gross Selling Price 210.00/kg 300.00/kg 280.00/kg 200.00/kg 80.00/kg 100.00/kg 6. Use SPSS to find the mean and standard deviation given the following data: 5.00 6.00 3.00 7.00 5.00 7. Use SPSS to find the mean and the standard deviation given the following data: 8.50 9.50 7.00 6.50 5.75 8. Use SPSS to find the mean and the standard deviation given the following data: 11.00 12.00 10.00 5.00 6.00

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_2

Step: 3

blur-text-image_3

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

Horngrens Cost Accounting A Managerial Emphasis

Authors: Srikant Datar, Madhav Rajan

16th Global Edition

1292211547, 9781292211541

More Books

Students also viewed these Accounting questions

Question

highlight how to collect and record interview and diary based data;

Answered: 1 week ago

Question

clarify the relationship between research, theory and practice;

Answered: 1 week ago

Question

evaluate the quality of your data;

Answered: 1 week ago