Question
Webster Company has the following sales budget. January $200,000 February $240,000 March $300,000 April $360,000 Cost of sales is 70% of sales. Sales are collected
Webster Company has the following sales budget.
January | $200,000 |
February | $240,000 |
March | $300,000 |
April | $360,000 |
Cost of sales is 70% of sales. Sales are collected 40% in the month of sale and 60% in the following month. Webster keeps inventory equal to double the coming month's budgeted sales requirements. It pays for purchases 80% in the month of purchase and 20% in the month after purchase. Inventory at the beginning of January is $190,000. Webster has monthly fixed costs of $30,000 including $6,000 depreciation. Fixed costs requiring cash are paid as incurred.
a. Compute budgeted cash receipts in March.
b. Compute budgeted accounts receivable at the end of March.
c. Compute budgeted inventory at the end of February.
d. Compute budgeted purchases in February.
e. March purchases are $290,000. Compute budgeted cash payments in March to suppliers of goods
f. Compute budgeted accounts payable for goods at the end of February.
g. Cash at the end of February is $45,000. Cash disbursements are not required for anything other than payments to suppliers and fixed costs. Compute the budgeted cash balance at the end of March.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started