Answered step by step
Verified Expert Solution
Question
1 Approved Answer
On Monday morning, Sokowatch purchased the following products and quantities: Product Quantity Purchased Unit Cost Price (Ksh) Maize Flour 100 bags 200 Cooking Oil 25
On Monday morning, Sokowatch purchased the following products and quantities: Product Quantity Purchased Unit Cost Price (Ksh) Maize Flour 100 bags 200 Cooking Oil 25 cartons 350 Toilet Paper 80 bags 550 Soap 50 cartons 150 Washing Powder 40 bags 250 During the day on Monday, Sokowatch sold the following products and quantities: Product Quantity Purchased Unit Sale Price (Ksh) Maize Flour 15 bags 210 Cooking Oil 4 cartons 400 Toilet Paper 8 bags 600 Soap 6 cartons 175 Washing Powder 5 bags 300 Please show your work for the following questions in Excel: 1. How much did Sokowatch pay for its purchases on Monday? 2. What is the total amount received in sales on Monday? 3. Which product yields the highest gross margin (percentage profitability)? 4. Which was the highest-selling product on Monday (by Ksh sales)? What percentage of total sales does that product represent? 5. What quantities of each product were remaining after sales on Monday? 6. If the quantities sold on Monday are the same quantities sold every day, which product would you expect to run out of stock first
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started