You work for a household appliance store, and your manger has asked you to prepare a...

Transcribed Image Text:

You work for a household appliance store, and your manger has asked you to prepare a sales report based on the information contained in the following table. Include a recommendation section for your manager. PRODUCT Kitchen appliances Refrigerators Dish washers Freezers Electric ranges OCTOBER 72 27 10 26 NUMBER SOLD NOVEMBER 103 14 36 26 Gas ranges Microwaves Laundry Appliances Washers Dryers RUBRIC Criteria 10 31 50 24 Use of English Conventions: Grammar, spelling. Mechanics: punctuation; capitalization Total Organization Organized the report using appropriate memo format; headings Documented data for all categories and totals Content Provided accurate data on quantities sold or services provided Explained the importance of the data (including sales figures as evidence) Made three recommendations based on the sales. 46 Air treatments Room air conditioners 41 Dehumidifiers 7 Figl: Table illustrating products being offered and the number of items sold during the financial year. 75 56 36 69 2 Possible Marks 25 5 2 5 3 5 Marks Earned Question a. The table below shows a shopping bill prepared for Ms. Rowe. The prices of some items are missing. Item 3 kg sugar 4 kg rice 2 kg flour i. ii. Unit Cost Price X SHOPPING BILL Y $160.00 Total cost price $180.00 Z $320.00 Calculate the value of X, the cost of 1 kg of sugar (1 mark) If the cost of 1 kg of rice is $10.00 more than for 1 kg of flour. Calculate the value of Y and Z. (2 marks) iii. b. Orange juice is sold in cartons of three different sizes. A tax of 16% of total cost price of the three items is added to Ms. Rowe's bill. What is Ms. Rowe's total including tax (3 marks) Carton sizes 350 ml 450 ml 500 ml i. i. ii. Selling price $420.00 $535.00 $580.00 Which size of orange juice is the most cost-effective purchase. Justify your answer. (3 marks) c. Paul bought and sold a computer. He wrote his business activity as follows: Cost price of computer - $60,000 Marked price of computer - $100,000 Discount on marked price -5% (if paid by cash) Calculate The selling price (paid by cash) (2 marks) The profit or loss as a percentage of the cost price (2 marks) You work for a household appliance store, and your manger has asked you to prepare a sales report based on the information contained in the following table. Include a recommendation section for your manager. PRODUCT Kitchen appliances Refrigerators Dish washers Freezers Electric ranges OCTOBER 72 27 10 26 NUMBER SOLD NOVEMBER 103 14 36 26 Gas ranges Microwaves Laundry Appliances Washers Dryers RUBRIC Criteria 10 31 50 24 Use of English Conventions: Grammar, spelling. Mechanics: punctuation; capitalization Total Organization Organized the report using appropriate memo format; headings Documented data for all categories and totals Content Provided accurate data on quantities sold or services provided Explained the importance of the data (including sales figures as evidence) Made three recommendations based on the sales. 46 Air treatments Room air conditioners 41 Dehumidifiers 7 Figl: Table illustrating products being offered and the number of items sold during the financial year. 75 56 36 69 2 Possible Marks 25 5 2 5 3 5 Marks Earned Question a. The table below shows a shopping bill prepared for Ms. Rowe. The prices of some items are missing. Item 3 kg sugar 4 kg rice 2 kg flour i. ii. Unit Cost Price X SHOPPING BILL Y $160.00 Total cost price $180.00 Z $320.00 Calculate the value of X, the cost of 1 kg of sugar (1 mark) If the cost of 1 kg of rice is $10.00 more than for 1 kg of flour. Calculate the value of Y and Z. (2 marks) iii. b. Orange juice is sold in cartons of three different sizes. A tax of 16% of total cost price of the three items is added to Ms. Rowe's bill. What is Ms. Rowe's total including tax (3 marks) Carton sizes 350 ml 450 ml 500 ml i. i. ii. Selling price $420.00 $535.00 $580.00 Which size of orange juice is the most cost-effective purchase. Justify your answer. (3 marks) c. Paul bought and sold a computer. He wrote his business activity as follows: Cost price of computer - $60,000 Marked price of computer - $100,000 Discount on marked price -5% (if paid by cash) Calculate The selling price (paid by cash) (2 marks) The profit or loss as a percentage of the cost price (2 marks)