her sales reports and records for the months of January through August of the current year.

You have been recently hired as general manager of Lucky’s. It is September 1, and you must prepare the operating budget of this establishment for the first quarter of the upcoming calendar year, and submit it to the corporate office. Since you have been at the operation for only a month or so, you must rely solely on historical data. You gather sales reports and records for the months of January through August of the current year.

Using the data and the budget worksheet provided, prepare the operating budget for Lucky’s for the months of January through March of the upcoming year. Here is the information you determined from the most recent sales and costs records (Please note that the first month has already been completed):  

• Sales are 10 percent higher than those of the same month during the previous year.
• Food cost percentage is steady at 32 percent.
• Fixed labor costs are steady at $9,000 per month.
• Variable labor costs are 15 percent of sales.
• Occupancy costs will remain steady at $2,000 per month.
• Other controllable costs are expected to be $10,000 per month.
• Marketing costs have been fixed at $1,000 per month.
• For January, February, and March of last year, Lucky’s sales revenues were as follows:
  • January: $60,000
  • February: $50,000
  • March: $55,000

Attached is the template.