I am trying to make a flexible budget for my case assignment. In learning examples, they provide information such as units and unit prices, or make flexible budgets based off of these different units or percentages. Yet in my case, I am suppose to make a flexible budget based off of revenues. I am not quite sure how to do that.

I have provided the information to the case.

I am not sure where to start or how to make a flexible budget using just the revenue, and figuring out the percentages from there.

T&P Fashions - Houston Store Breakdown of Expenses (Forecast) Forecast Fixed Variable Actual Revenues $1.400,000 $1.260,000 Cost of Sales 790.000 790,000 760.000 Gross Profit $610,000 $500,000 Management 182,000 154,700 27.300 182,000 Shop assistants 258.000 154.800 103.200 262.000 Rent 23.200 18.560 4.640 22.000 Utilities 34.800 34.800 31.000 Misc. expenses 24.500 12,250 12.250 29.000 Total expenses $522.500 $526.000 Net income $87.500 S(26.000) Additional Information . Variable expenses are based on revenues and we assume that the percentage remains constant for flexible budgeting purposes. . Fixed costs are all within the relevant range. . Other expenses are all specific to this store. Headquarters pay for marketing and corporate overhead expenses