Sign in
Please select an account to continue using cracku.in
↓ →
Each of the Big, Small and Medium cost is categorized by the manager into Red, Yellow, Green and Violet costs. Breakdown of the additional costs under these headings is shown in the table below:
Red, Yellow, Green and Violet costs are allocated to different retail formats. These costs are apportioned in the ratio of number of units consumed by each retail format. The number of units consumed by each retail format is given in the table below:
Sales from online = 50% of total sales = 50% of 60000 = 30000
The ratio of supermarket sales and book store sales is 1:2
Supermarket sales = (30000*1)/3 = 10000
Bookstore sales = (30000*2)/3 = 20000
Initial costs for online = 50% of total initial costs (Initial cost is allocated in ratio of sales)
= 50% of 39000 = 19500
Initial costs for supermarket = (19500*1)/3 = 6500 (Initial cost is allocated in ratio of sales)
Initial costs for bookstore = (19500*2)/3 = 13000
For online:
Additional costs = Red + Yellow + Green + Violet for online) ....(1)
Total red costs = 5500
Red costs for online = 5500*(200/275) = 4000
Similarly,
Yellow costs for online = 3100*(52/100) = 1612
Green costs for online = 4800*(50/80) = 3000
Violets costs for online = 2400*(50/80) = 1500
Addition costs for online = 4000+1612+3000+1500 = 10112 From (1)
Profit = Sales - Initial costs - Additional costs = 30000-19500- 10112 = 388
For Supermarket:
Additional costs = Red + Yellow + Green + Violet
= 5500*(65/275) + 3100*(20/100) +4800*(21/80)+2400*(21/80) = 3810
Profit = 10000-6500- 3810
= -310
For Bookstore:
Additional costs = Red + Yellow + Green + Violet
= 5500*(10/275) + 3100*(30/100) +4800*(9/80)+2400*(9/80)
Profit = 20000-13000-1940 = 5060
Supermarket is making least profit for BnC.
Create a FREE account and get: