Cash Budget for Accounting 2

profilejosphd

Sales for July, August, and September are expected to be $200,000, $180,000, and $220,000, respectively, for Pasta Company.  All sales are on account and are collected 50 percent in the month of the sale and 50 percent in the following month.  On average, customers take a one percent sales discount in the first month.  Raw materials are purchased one month before being needed, and all purchases and expenses are paid for as incurred.  Activities for the quarter are expected to be:

 

 

 JulyAugustSeptember
Raw materials used$40,000$36,000$44,000
Salaries70,00068,00092,000
Maintenance and repairs18,00018,00018,000
Depreciation36,00036,00036,000
Utilities and other14,00014,00015,000
Dividends paid-0-10,000-0-
Payment on bonds8,0008,0008,000
    
Using the given information, prepare a cash budget for August.
  • 12 years ago
  • 20
Answer(3)

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    pasta_company.xlsx

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    exam.xlsx

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    pasta_company_cash_budget.xlsx