Icy Treats, Inc., is a seasonal business that sells frozen desserts. At the peak of its summer selling season the firm has $35,000 in cash, $125,000 in inventory, $70,000 in accounts receivable, and $65,000 in accounts payable. During the slow winter period the firm holds $10,000 in cash, $55,000 in inventory, $40,000 in accounts receivable, and $35,000 in accounts payable. Calculate Icy Treats’ minimum and peak funding requirements.

Icy Treats, Inc., is a seasonal business that sells frozen desserts. At the peak of its summer selling season the firm has $35,000 in cash, $125,000 in inventory, $70,000 in accounts receivable, and $65,000 in accounts payable. During the slow winter period the firm holds $10,000 in cash, $55,000 in inventory, $40,000 in accounts receivable, and $35,000 in accounts payable. Calculate Icy Treats’ minimum and peak funding requirements.

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter7: Budgeting

Section: Chapter Questions

Problem 14EB: Earthies Shoes has 55% of its sales in cash and the remainder on credit. Of the credit sales, 70% is...

See similar textbooks

Similar questions

Halifax Shoes has 30% of its sales in cash and the remainder on credit. Of the credit sales, 65% is collected in the month of sale, 25% is collected the month after the sale, and 5% is collected the second month after the sale. How much cash will be collected in August if sales are estimated as $75,000 in June, $65,000 in July, and $90,000 in August?
Icy Treats Inc. is a seasonal business that sells frozen desserts. At the peak of its summer selling season, the firm has P45,000 in cash, P120,000 in inventory, P80,000 in accounts receivable and P65,000 in accounts payable. During the slow winter period, the firm holds P10,000 in cash, P40,000 in inventory, P60,000 in accounts receivable and P25,000 in accounts payable. Requirement: Calculate Icy Treat’s minimum and peak funding requirements
a) Sharam Industries has a 120-day operating cycle. If its average age of inventory is 50 days, how long is its average collection period ? If its average payment period is 30 days, what is its cash conversion cycle ? b) Icy Treats, Inc., is a seasonal business that sells frozen desserts. At the peak of its summer selling season the firm has $35,000 in cash, $125,000 in inventory, $70,000 in accounts receivable, and $65,000 in accounts payable. During the slow winter period the firm holds $10,000 in cash, $55,000 in inventory, $40,000 in accounts receivable, and $35,000 in accounts payable. Calculate Icy Treats’ minimum and peak funding requirements.
Chai Me, Inc., a merchandiser of herbal tea products, began operations on January 1. The company expects sales in its first month of operations to total $18,000. 80% of the sales are expected to be cash sales. The remaining sales are expected to be on account and will carry payment terms of net 30. The company estimates that 99% of its sales on account will be collected in the month following the month of sale. The remaining 1% is deemed uncollectible. The company will recognize bad debt expense under the allowance method of accounting for bad debts in the month in which the credit sales occur. Inventory purchases during January are expected to equal $4,000. Purchases are paid for in the month of purchase. No purchase discounts are available. Chai pays its sales staff a 10% commission on all sales made. The commission expense is recognized in the month of sale and is paid on the 10th of the following month. Chai’s expected fixed monthly operating expenses are $4,570.…
During February, the last month of the fiscal year, Be My Valentine Ltd. sells $21,400 of gift cards. From experience, management estimates that 8% of the gift cards sold will not be redeemed by customers. In March, $4,600 of these cards is redeemed for merchandise with a cost of $2,500. In April, further $13,800 of these cards is redeemed for merchandise with a cost of $4,600. The company uses a perpetual inventory system. Also in February, Be My Valentine had $1,000 of unused gift cards that were over one year old and were not expected to be used. The amount was in line with the company's normal breakage and all other gift cards of the same age had been used.
During February, the last month of the fiscal year, Be My Valentine Ltd. sells $20,200 of gift cards. From experience, management estimates that 8% of the gift cards sold will not be redeemed by customers. In March, $4,600 of these cards is redeemed for merchandise with a cost of $2,500. In April, further $11,500 of these cards is redeemed for merchandise with a cost of $3,800. The company uses a perpetual inventory system. Also in February, Be My Valentine had $1,000 of unused gift cards that were over one year old and were not expected to be used. The amount was in line with the company's normal breakage and all other gift cards of the same age had been used. Your answer is correct. Prepare journal entries to record the transactions for February, March, and April. (Enter debit entries first followed by credit entries. Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No entry" for the account titles…
Meadows Company makes all of its sales on account. Meadows collect its accounts as follows: 70% in the month of sale, 25% in the month following sale, and 4% in the second month following sale. Uncollectible accounts are 1% of sales. Meadows expects sales for the first three months of the year to be as follows: January 90,000; February 95,000; and March 100,000. How much cash should Meadows expect to collect in March.A. 99,000B.97,350C. 100,000D. 70,000
Best Breath is a retail store selling home oxygen equipment. Best Breath also services home oxygen equipment, for which the company bills customers monthly. Best Breath has budgeted for increases in service revenue of $100 each month due to a recent advertising campaign. The forecast of sales and service revenue for March-June 2018 is as follows: Almost all of the sales revenues of the oxygen equipment are credit card sales; cash sales are negligible. The credit card company deposits 97% of the revenues recorded each day into Best Breath's account overnight. For the servicing of home oxygen equipment, 75% of oxygen services billed each month is collected in the month of the service, and 25% is collected in the month following the service.
Jasper Company has 61% of its sales on credit and 39% for cash. All credit sales are collected in full in the first month following the sale. The company budgets sales of $527,000 for April, $537,000 for May, and $562,000 for June. Total sales for March are $302,600. Prepare a schedule of cash receipts from sales for April, May, and June. Answer is not complete. JASPER COMPANY Schedule of Cash Receipts from Sales April May June Sales 527,000 537,000 562,000 Cash receipts from: 205,530 Os 209,430 O$ 219,180 Cash sales Collections of prior period sales Total cash receipts
Kent Corner Shoppe is a local convenience store with the following information: October sales were $250,000. Sales are projected to go up by 12% in November and another 30% in December and then return to the October level in January. 20% of sales are made in cash, while the remaining 80% are paid by credit or debit cards. The credit card companies and banks (debit card issuers) charge a 2% transaction fee and deposit the net amount (sales price less the transaction fee) in the store’s bank account daily. Kent Corner Shoppe’s gross profit is 25% of its sales revenue. For the next several months, the store wants to maintain an ending merchandise inventory equal to $15,000+15%$15,000+15% of the next month’s cost of goods sold. The September 30 inventory was $43,125. Expected monthly operating expenses include: Wages of store workers are $9,200 per month Utilities expense of $1,000 in November and $1,500 in December Property tax expense of $2,000 per month Property and liability…
Dollar Saver Store is a local discount store with the following information: • October sales are projected to be $300,000. • Sales are projected to increase by 15%in November and another 30% in December and then return to the October level in January. • 20% of sales are made in cash while the remaining 80% are paid by credit or debit cards. The credit card companies and banks (debit card issuers) charge a 1% transaction fee, and deposit the net amount (sales price less the transaction fee) in the store's bank account daily. The store does not accept checks. Because of the payment mechanisms, there is no risk of non-payment or bad-debts. • The store's gross profit is 25% of its sales revenue. For the next several months, the store wants to maintain an ending merchandise inventory equal to $12,000 plus 20%of the next month's cost of goods sold. All purchases for merchandise are made on account and paid in the…
A company based in Montreal, Quebec has a cash balance of $15,000 as of June 1. During the month they paid $18,000 on account, $13,000 for wages, and $1,000 for other expense items. The company maintains a minimum cash balance of $10,000. Sales for the firm for April, May, and June are $15,000, $22,000, and $18,750, respectively. The company collects 40% of sales in the month of sale, 50% in the following month, and 10% in the second month following the month of sale. What is the cash surplus or deficit as of June 30, relative to the company's required minimum cash balance?