Cash Budget for Accounting 2

josphd

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

NOT RATED
  • pasta_company.xlsx

Purchase the answer to view it

NOT RATED
  • exam.xlsx

Purchase the answer to view it

NOT RATED
  • pasta_company_cash_budget.xlsx