Please present the answer in Lakhs.

*Provide workings with adequate formula and calculation workings for each step. (Please don't paste screenshots of excel formula) Requirements : 1) Statement of Profit ans loss for April to June 2) Cash budget

This should be the answer : Profit (Apl -June) : 233.80 , 221.80, 221.80 cash balance (apl-june) : 249.33, 489.20 , 712.10

note : I don't want separate screenshot of formulas used in excel. before applying any formula, if you mention it that's enough (eg :Variable cost = 40% of sales)

In your Company, Bud (a) Cash Sales 17.49 llustration 23: Cash Budget mpany, Budgeted Sales for following months of a year are given below - Month RTP March Sales in Lakhs) April 600.00 May June July Aug 620. 00 6 20.00 630.00 6 40.00 Cash Sales is 20% and Credit Sales is 80%. Credit for one month only. b) Contribution/Sales Ratio is 40% al Fixed Cost for the whole year is budgeted to be