60.1K

Verified Solution

Link Copied!

kindly solve this on a Excel sheet only

fx B D E 1 Post Mid Term - Assignment No 1 - Deriving Profitability from Business Indicators II The following infnormation is provided to you about ABC Bakery for the month of April 2021. You are requested to compute the profitability of the bakery and the return on investments on annuallized basis assuming the figures of April are annual average figures 2 A. Business Information Unit Values 3 4 Daily Footfalls in the bakery Nos 250 5 Footfalls to purchase ratio % 82.0% 6 Average spending per customer Rs 260 7 No of days the bakery is open in April Days 25 8 B. Average Product Margin on sale value % 24.0% C. Manpower employed by the bakery No of Employees Salary / PM 9 10 Supervisor 1 22,000 11 Salesmen at the counter 3 14,000 12 Helpers and cleaning staff 1 11,000 13 D. Other Expenses 14 Electricity and Power Expenses Rs / Mth 35,000 15 Miscellaneous running expenses Rs / Mth 28,000 16 E. Capital Investment make in the Bakery 17 Cost of Shop Rs 6,000,000 18 Furnishing & Fixtures Rs 600,000 19 Equipmetns Rs 900,000 20 Working Capital Rs 500,000 21 Total Investments Rs 8,000,000 22 G. Deprecitaion on Fixed Assetts 23 Cost of Shop % / Year 0.0% 24 Furnishing & Fixtures % / Year 30.0% 25 Equipmetns % / Year 27.0% 26 H. Income Tax Rate % / Yr 22.0% 27 28 29 30 31 32 33 34 25

Answer & Explanation Solved by verified expert

See Answer