Create a worksheet to record sales of home appliances sold by M/s Home Maker Ltd. In the
Question:
Create a worksheet to record sales of home appliances sold by M/s Home Maker Ltd. In the following format:
The product lists include Television sets, Refrigerators, Microwave ovens, Water Coolers, Air Coolers, Geezers and Air conditioners of different Makes (and models). The cost of price of television is ranging from Rs. 10,000 to Rs. 56,000; refrigerator is Rs. 13,000 to Rs. 45,000, micro wave ovens, water coolers, geezers and air coolers are from Rs. 8,000 to Rs. 25,000 and Air Conditioners are from Rs. 18,000 to Rs. 55,000. The shopkeeper sales these products adding 17.25% more on cost price. He provides a discount of 4.35% on total amount if any customer purchases two products on the same date.
Questions:
A. Write a formula to enter 30 random records of different dates (for a month) and different customers accordingly.
B. Calculate the following:
I. Product-wise weekly sales and discount.
II. Calculate the total sales when the make is after Jan 2015 and sales amount is more than 50K.
III. Product-wise total sales of the month and discount offered.