Question

In: Accounting

Preparing a Cash Budget La Famiglia Pizzeria provided the following information for the month of October:...

  1. Preparing a Cash Budget

    La Famiglia Pizzeria provided the following information for the month of October:

    1. Sales are budgeted to be $161,000. About 85% of sales is cash; the remainder is on account.
    2. La Famiglia expects that, on average, 70% of credit sales will be paid in the month of sale, and 28% will be paid in the following month.
    3. Food and supplies purchases, all on account, are expected to be $113,000. La Famiglia pays 25% in the month of purchase and 75% in the month following purchase.
    4. Most of the work is done by the owners, who typically withdraw $6,000 a month from the business as their salary. (Note: The $6,000 is a payment in total to the two owners, not per person.) Various part-time workers cost $7,300 per month. They are paid for their work weekly, so on average 90% of their wages are paid in the month incurred and the remaining 10% in the next month.
    5. Utilities average $5,950 per month. Rent on the building is $4,100 per month.
    6. Insurance is paid quarterly; the next payment of $1,200 is due in October.
    7. September sales were $181,500 and purchases of food and supplies in September equaled $130,000.
    8. The cash balance on October 1 is $2,147.

    Required:

    If required, round your answers to the nearest dollar.

    1. Calculate the cash receipts expected in October.
    $

    2. Calculate the cash needed in October to pay for food purchases.
    $

    3. Prepare a cash budget for the month of October.

    La Famiglia Pizzeria
    Cash budget
    For the month of October
    Beginning balance $
    Cash receipts
    Cash available $
    Less:
    Payments for food and supplies purchases $
    Owners' draw
    Workers' wages
    Utilities
    Rent
    Insurance
    Total disbursements $
    Ending balance $

Solutions

Expert Solution


Related Solutions

Preparing a Cash Budget La Famiglia Pizzeria provided the following information for the month of October:...
Preparing a Cash Budget La Famiglia Pizzeria provided the following information for the month of October: Sales are budgeted to be $167,000. About 85% of sales is cash; the remainder is on account. La Famiglia expects that, on average, 70% of credit sales will be paid in the month of sale, and 28% will be paid in the following month. Food and supplies purchases, all on account, are expected to be $102,000. La Famiglia pays 25% in the month of...
Preparing a Cash Budget La Famiglia Pizzeria provided the following information for the month of October:...
Preparing a Cash Budget La Famiglia Pizzeria provided the following information for the month of October: Sales are budgeted to be $153,000. About 85% of sales is cash; the remainder is on account. La Famiglia expects that, on average, 70% of credit sales will be paid in the month of sale, and 28% will be paid in the following month. Food and supplies purchases, all on account, are expected to be $101,000. La Famiglia pays 25% in the month of...
Preparing a Cash Budget La Famiglia Pizzeria provided the following information for the month of October:...
Preparing a Cash Budget La Famiglia Pizzeria provided the following information for the month of October: Sales are budgeted to be $162,000. About 85% of sales is cash; the remainder is on account. La Famiglia expects that, on average, 70% of credit sales will be paid in the month of sale, and 28% will be paid in the following month. Food and supplies purchases, all on account, are expected to be $103,000. La Famiglia pays 25% in the month of...
Preparing a Cash Budget La Famiglia Pizzeria provided the following information for the month of October:...
Preparing a Cash Budget La Famiglia Pizzeria provided the following information for the month of October: Sales are budgeted to be $166,000. About 85% of sales are cash; the remainder are on account. La Famiglia expects that, on average, 70% of credit sales will be paid in the month of sale, and 28% will be paid in the following month. Food and supplies purchases, all on account, are expected to be $113,000. La Famiglia pays 25% in the month of...
Preparing a Cash Budget La Famiglia Pizzeria provided the following information for the month of October:...
Preparing a Cash Budget La Famiglia Pizzeria provided the following information for the month of October: Sales are budgeted to be $161,000. About 85% of sales is cash; the remainder is on account. La Famiglia expects that, on average, 70% of credit sales will be paid in the month of sale, and 28% will be paid in the following month. Food and supplies purchases, all on account, are expected to be $96,000. La Famiglia pays 25% in the month of...
Preparing a Cash Budget La Famiglia Pizzeria provided the following information for the month of October:...
Preparing a Cash Budget La Famiglia Pizzeria provided the following information for the month of October: Sales are budgeted to be $163,000. About 85% of sales is cash; the remainder is on account. La Famiglia expects that, on average, 70% of credit sales will be paid in the month of sale, and 28% will be paid in the following month. Food and supplies purchases, all on account, are expected to be $108,000. La Famiglia pays 25% in the month of...
Preparing a Cash Budget La Famiglia Pizzeria provided the following information for the month of October:...
Preparing a Cash Budget La Famiglia Pizzeria provided the following information for the month of October: Sales are budgeted to be $154,000. About 85% of sales is cash; the remainder is on account. La Famiglia expects that, on average, 70% of credit sales will be paid in the month of sale, and 28% will be paid in the following month. Food and supplies purchases, all on account, are expected to be $113,000. La Famiglia pays 25% in the month of...
Preparing a Cash Budget La Famiglia Pizzeria provided the following information for the month of October:...
Preparing a Cash Budget La Famiglia Pizzeria provided the following information for the month of October: Sales are budgeted to be $152,000. About 85% of sales is cash; the remainder is on account. La Famiglia expects that, on average, 70% of credit sales will be paid in the month of sale, and 28% will be paid in the following month. Food and supplies purchases, all on account, are expected to be $117,000. La Famiglia pays 25% in the month of...
La Famiglia Pizzeria provided the following information for the month of October: a. Sales are budgeted...
La Famiglia Pizzeria provided the following information for the month of October: a. Sales are budgeted to be $157,000. About 85% of sales is cash; the remainder is on account. b. La Famiglia expects that, on average, 70% of credit sales will be paid in the month of sale, and 28% will be paid in the following month. c. Food and supplies purchases, all on account, are expected to be $116,000. La Famiglia pays 25% in the month of purchase...
Papst Company is preparing its cash budget for the month of May. The following information is...
Papst Company is preparing its cash budget for the month of May. The following information is available concerning its accounts receivable (based on sales made to customers on open account): Actual credit sales for March $ 130,000 Actual credit sales for April $ 160,000 Estimated credit sales for May $ 210,000 Estimated collections in the month of sale 25 % Estimated collections in the first month after the month of sale 60 % Estimated collections in the second month after...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT