Answered step by step
Verified Expert Solution
Question
1 Approved Answer
May was Frost's Frozen Treats first month in business. It provided the following cash budget information: Cash collection and disbursement activity May June July August
May was Frost's Frozen Treats first month in business. It provided the following cash budget information: Cash collection and disbursement activity May June July August September October Sales revenue $85,100 $62,900 $67,100 $49,200 $50,800 $68,200 Purchases of raw material $7,664 $7,240 $7,500 $6,850 $6,900 $7,575 Other manufacturing overhead costs $2,022 $1,904 $2,323 $2,377 $1,327 $1,475 Direct labour wages $30,360 $22,440 $23,958 $17,556 $18, 150 $24,354 Management salaries $25,417 $25,417 $25,417 $25,417 $25,417 $25,417 General operating expenses $2,390 $2,390 $2,390 $2,390 $2,390 $2,390Cash collections: Cash sales Credit collections: Amount collected in month of sale Amount collected in month following sale Amount collected in second month following sale Uncollectable Cash disbursements: Conyersion costs 100% Raw materials 50% 40% Direct labour 50% 50% Remaining expenses 100% Additional notes: Depreciation included in monthly general operating expenses Annual dividend payment to the shareholders, paid in August Paid in month incurred Paid in month incurred Paid in month following Paid in month incurred Paid in month following Paid in month incurred Expected May 1 beginning cash balance Frost's Frozen Treats can borrow funds from its bank in $1,000 increments. The company wants to maintain a minimum balance in the bank of $5.000. Interest is paid the following month on the balance due the preyious month at a rate of 1.5% per month and any loans are paid in $1,000 increments as soon as the company is able to while still maintaining the $5,000 minimum balance. 25% 50% 30% 1 5% 5% $ 195 $3,000 $s,ooo
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