Question
Delsing Company expects its revenues and payments for the first part of the year to be: UnitsSalesPayments $$ January4,800$24,000$18,000 February4,00020,00021,300 March7,00035,00019,100 April4,40022,00022,400 May5,60028,00014,700 Delsing Company
Delsing Company expects its revenues and payments for the first part of the year to be:
UnitsSalesPayments
$$
January4,800$24,000$18,000
February4,00020,00021,300
March7,00035,00019,100
April4,40022,00022,400
May5,60028,00014,700
Delsing Company wants ending inventory to be equal to 20% of the following month's budgeted sales.80% of the firm's sales are on credit. Past experience shows that 40% of accounts receivable are collected in the month of sale, and the remainder is collected in the month following sale. Delsing pays its payments in the following month.
Company had a cash balance of $2,000 on March 1, which is also its minimum required cash balance. There is an outstanding loan of $10,000 on March 1. At the end of each month, the company makes a payment to repay the loan if excess cash is available. The 12% per annum interest calculated on the beginning balance is paid monthly.
Required:
(a) production budget for March and April
(b)schedule of cash receipts for March and April.
(c)cash Budget for March and April
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