Jupiter\'s Pizzeria & Billiards is a sports-minded pub with pizza, a large beer
ID: 2510407 • Letter: J
Question
Jupiter's Pizzeria & Billiards is a sports-minded pub with pizza, a large beer selection, pool tables and a handful of arcade games. Jupiter's Pizzeria & Billiards had budgeted revenues for last year of $41,500, and budgeted expenses of $31,250. The pub’s sales last year were $43,100 and its expenses totaled $30,700.
The estimates made by the Jupiter's Pizzeria & Billiards manager are as follows:
Jupiter's Pizzeria & Billiards’ sales will increase by 3.2% this year.
Jupiter's Pizzeria & Billiards’ expenses will increase by 2.4% this year.
Jupiter's Pizzeria & Billiards’ manager assumes a target food cost of 30%.
Jupiter's Pizzeria & Billiards’ manager forecasts the labor cost for this year will be $9,400, and she assumes last year’s payroll allocation of 8.75% will not change.
What was Jupiter's Pizzeria & Billiards’ budgeted profit for last year?
What is Jupiter's Pizzeria & Billiards’ sales forecast?
What is Jupiter's Pizzeria & Billiards’ expense forecast?
What was Jupiter's Pizzeria & Billiards’ expense variance based on last year’s budget?
What is Jupiter's Pizzeria & Billiards’ forecasted food cost for this year?
What should Jupiter's Pizzeria & Billiards’ managers budget for payroll allocations?
Jupiter's Pizzeria & Billiards’ manager is concerned about the pub’s accounts receivable. The pub currently has $5,000 in accounts receivable, with aging of accounts as 45% in less than 30 days, 40% in 30-60 days, 10% in 60-90 days, and 5% in 90+ days. What dollar amount of the pub’s accounts receivable can Jupiter's Pizzeria & Billiards’ manager expect to receive 30-60 days from now?
Explanation / Answer
1. Jupiter's Pizzeria & Billiards had budgeted revenues for last year of $41,500, and budgeted expenses of $31,250. Profit = $ 10250
2. Sales forcase = $ 43100 * 1.032 = $ 44479.20
3. Expenses Forecast: $ 31250 x 1.024 = $ 32000
4. Favourable Variance of $ 550
An expert is allowed to answr initial 4 qtns in case of multi part qtns. Please repost for the rest. Thanks