Concept explainers
The company sells many styles of earrings, but all are sold for the same price - $10 per pair. Actual sales of earrings for the last three months and budgeted sales for the next six months follow:
January (actual) |
20,000 |
February (actual) |
26,000 |
March (actual) |
40,000 |
April (budget) |
65,000 |
May (budget) |
100,000 |
June (budget) |
50,000 |
July (budget) |
30,000 |
August (budget) |
28,000 |
September (budget) |
25,000 |
The concentration of sales before and during May is due to Mother’s Day. Sufficient inventory should be on hand at the end of each month to supply 40% of the bracelets sold in the following month.
Suppliers are paid $4 for each bracelet. One-half of a month's purchases is paid for in the month of purchase; the other half is paid for in the following month. All sales are on credit with no discounts. The company has found, however, that only 20% of a month's sales are collected in the month of sale. An additional 70% is collected in the following month, and the remaining 10% is collected in the second month following sale.
Monthly operating expenses for the company are given below:
Variable expenses:
Sales commissions 4% of sales
Fixed expenses:
Advertising $200,000
Rent $18,000
Salaries $106,000
Utilities $ 7,000
Insurance $3,000
Insurance is paid on an annual basis, in November of each year.
The company plans to purchase $16,000 in new equipment during May and $40,000 in new equipment during June; both purchases will be for cash. The company declares dividends of $15,000 each quarter, payable in the first month of the following quarter.
Other relevant data is given below:
Cash balance as of March 31 $74,000
Inventory balance as of March 31 $104,000
Merchandise purchases for March $200,000
The company maintains a minimum cash balance of at least $50,000 at the end of each month. All borrowing is done at the beginning of a month; any repayments are made at the end of a month.
The company has an agreement with a bank that allows the company to borrow the exact amount needed at the beginning of each month. The interest rate on these loans is 1% per month and for simplicity we will assume that interest is not compounded. At the end of the quarter, the company will pay the bank all of the accrued interest on the loan and as much of the loan as possible while still retaining at least $50,000 in cash.
Required:
Prepare a
I've performed the other budgets but i am having an issue creating the cash budget for this question.
- A cash budget. Show the budget by month and in total. Determine any borrowing that would be needed to maintain the minimum cash balance of $50,000.
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps
- Kimball Company manufactures drinking glasses. One unit is a package of eight glasses, which sells for $24. Kimball projects sales for April will be 2,500 packages, with sales increasing by 200 packages per month for May, June, and July. On April 1, Kimball has 100 packages on hand but desires to maintain an ending inventory of 20% of the next month's sales. Prepare a sales budget and a production budget for Kimball for April, May, and June. Begin by preparing a sales budget for April, May, and June. Kimball Company Sales Budget April, May, and June April May Budgeted packages to be sold Sales price per package Total sales 697 2,500 2,700 24 $ 60,000 $ 64,800 24 $ $ June 2,900 Total 8,100 24 24 $ 69,600 $ 194,400arrow_forwardJackson Inc. produces leather handbags. The production budget for the next four months is: July 5,300 units, August 7,700 units, September 8,400 units, October 8,100 units. Each handbag requires 0.5 square meters of leather. Jackson Inc.’s leather inventory policy is 30% of next month’s production needs. On July 1 leather inventory was expected to be 795 square meters. What will leather purchases be in July? Multiple Choice 2,760 square meters 4,035 square meters 3,010 square meters 3,160 square metersarrow_forwardShamrock Shades purchases sunglasses from bulk discounters and sells the sunglasses in mall kiosks throughout the Pacific Northwest. Shamrock is in the process of budgeting for the coming year and has projected sales of $360,000 for January, $440,000 for February, $600,000 for March, and $640,000 for April. Shamrock's desired ending inventory is 55 percent of the following month's cost of goods sold. Cost of goods sold is expected to be 45 percent of sales. Required: Compute the required purchases for each month of the first quarter (January through March). January Required Purchases February Marcharrow_forward
- Dhapaarrow_forwardMultiple Choice Gallonte Inc. began operations in April of this year. It makes all sales on account, subject to the following collection pattern: 20% are collected in the month of sale; 70% are collected in the First month after sale; and 10% are collected in the second month after sale. If sales for April, May, and June were $80,000, $140,000, and $130,000, respectively, what were the firm's budgeted collections for the quarter? $201,000. $220,000. $232,000. $292,000. Help None of the answers is correct. Save & EXIL SUBarrow_forwardPrepare a production budget for the first four months of the year. Cloud Shoes manufactures recovery sandals and is planning on producing 12,000 units in March and 11,500 in April. Each sandal requires 1.2 yards if material, which costs $3.00 per yard. The company’s policy is to have enough material on hand to equal 15% of next month’s production needs and to maintain a finished goods inventory equal to 20% of the next month’s production needs. What is the budgeted cost of purchases for March?arrow_forward
- Magnolia Interior décor Industries manufactures wooden dining chairs. The selling price of the wooden dining chairs is $15 per unit. The company is preparing detailed budgets for the third quarter (Third quarter includes July, August and September) and fourth quarter (Fourth quarter includes October, November and December) and has assembled the following information to assist in the budget preparation (see below tables). Sales for June totaled $2,000. The company maintains finished goods inventories equal to 15% of the following month's sales. This requirement will be met at the end of June. Calculate the estimated quantity of wooden dining chairs that need to be produced in July. Estimated unit sales for the next several month Month Units July 100 August 200 September 300 October 200 November 200 300 December All sales are on account (i.e., on credit). These sales on account are usually collected in the following pattern: 65% in the month following sale 5% X 130 Correct Answer: 115…arrow_forwardSilver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur in May of each year, as shown in the company's sales budget for the second quarter given below: May April $ 490,000 $ 690,000 June $ 220,000 Total $1,400,000 Budgeted sales (all on account) From past experience, the company has learned that 25% of a month's sales are collected in the month of sale, another 60% are collected in the month following sale, and the remaining 15% are collected in the second month following sale. Bad debts are. negligible and can be ignored. February sales totaled $420,000, and March sales totaled $450,000. Required: 1. Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. 2. What is the accounts receivable balance on June 30th?arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education