Question

In: Accounting

Molly West is developing her retail firm’s budget. She provides you with the following budgeted sales...

Molly West is developing her retail firm’s budget. She provides you with the following budgeted sales data (in units) for the first five months of the year:

Sales in Units

January

6,400

February

5,800

March

6,000

April

6,100

May

5,600

Each unit sells for $50. Additionally, sales are billed on the last day of the month. For example, all customers making purchases from Molly during April will be sent a bill on April 30. Customers paying within 10 days of the billing date are granted a 4% discount. For example, if a customer purchases $100 worth of merchandise during April and pays her bill by May 10, then she would pay $96. 60% of sales are collected within 10 days of billing date (i.e., during the discount period), 25% within 11-30 days of the billing date, 10% within 31-60 days of the billing date, and 5% are never collected. There are no cash sales – all sales are on credit. (Please assume that each month has 30 days).

Molly pays for all of her inventory in cash during the month purchased. The number of units in each month’s ending inventory equals 110% of the next month’s sales in units. Each unit of merchandise inventory costs Molly $30 (i.e., Molly pays her supplier $30/unit). Selling costs, in total, equal 25% of the current month’s gross (i.e., before any discounts) revenue, and $10,000 of the total selling costs represents monthly non-cash depreciation. Finally, Molly pays 60% of the cash portion of the total selling costs in the month of incurrence and the remaining 40% in the following month.

1. What are the budgeted purchases in April?

2. What are the budgeted cash outflows in April?

3. What are the budgeted cash inflows in April?

Solutions

Expert Solution

ANSWERS ARE AS PER THE ABOVE ATTACHED WORKINGS:

ANS:1. The Budgeted Purchases in the month of April are 5,550 Units for $166,500

ANS:2. The Budgeted Cash Outflows in April are ($166,500 + $65,750) = $232,250

ANS:3  The Budgeted Cash Inflows in April are $276,800.

If you are satisfied with the answers please click LIKE button it really motivates us!


Related Solutions

-budgeted income statement – direct materials budget – production budget – sales budget -sales budget –...
-budgeted income statement – direct materials budget – production budget – sales budget -sales budget – production budget – direct materials budget – budgeted income statement Who would typically be responsible for the direct material quantity variance? -the production manager -the chief financial officer -the purchasing manager -the human resources manager Which of the following is not a component of the operating budget? -sales budget -selling and administrative budget -Budgeted balance sheet -raw materials purchases budget Top-down budgeting is: -when...
Molly is single and earns $150,000 in wages as a lawyer. Her employer withheld $30,000. She...
Molly is single and earns $150,000 in wages as a lawyer. Her employer withheld $30,000. She is also an equal co-owner in a real estate management partnership with her friend Issa. The partnership earned $8,000 this year. The following also occurred this year: Molly purchased a stock last year for $28,000 and sold the stock this year for $22,000. During this year and before the sale of the stock, the stock paid Molly $200 in dividends. Molly’s bank paid her...
The following information pertains to the January operating budget for Casey Corporation.         ∙       Budgeted sales...
The following information pertains to the January operating budget for Casey Corporation.         ∙       Budgeted sales for January $200,000 and February $107,000.         ∙       Collections for sales are 40% in the month of sale and 60% the next month.         ∙       Gross margin is 25% of sales.         ∙       Administrative costs are $11,000 each month.         ∙       Beginning accounts receivable is $26,000.         ∙       Beginning inventory is $15,000.         ∙       Beginning accounts payable is $68,000. (All from inventory purchases.)        ...
Which of the following sequences is correct? Select one a. Cash receipts budget-sales budget-production budget-budgeted income...
Which of the following sequences is correct? Select one a. Cash receipts budget-sales budget-production budget-budgeted income statement b. Sales budget-production budget-direct materials budget-budgeted income statement c Budgeted income statement-direct materials budget-production budget-sales budget O d Inventory budget-production budget-sales budget-selling and administrative budger
After 20 minutes of being brought to the birthing suite, Molly birthed her baby. She had...
After 20 minutes of being brought to the birthing suite, Molly birthed her baby. She had a healthy baby girl who immediately cried at birth, heart rate of 96bpm, active motion, cried on stimulation, and had a pink trunk and blue extremities, Initiation of skin to skin contact. The placenta was delivered intact with minimal bleeding. Question: 1. Discuss APGAR Scoring of the newborn 2. Outline the five (5) immediate needs of the newborn 3. Outline the steps of the...
Lilly Inc. bases its selling and administrative expense budget on budgeted unit sales. The sales budget...
Lilly Inc. bases its selling and administrative expense budget on budgeted unit sales. The sales budget shows 3,200 units are planned to be sold in December. The variable selling and administrative expense is $3.10 per unit. The budgeted fixed selling and administrative expense is $60,800 per month, which includes depreciation of $6,720 per month. The remainder of the fixed selling and administrative expense represents current cash flows.Calculate the budgeted cash disbursements for selling and administrative expenses for December. Give your...
Brownsville Novelty Store prepared the following budget information for the month of May: Sales are budgeted...
Brownsville Novelty Store prepared the following budget information for the month of May: Sales are budgeted at $381,000. All sales are on account and a provision for bad debts is made for each month at three percent of sales for the month. Inventory was $104,000 on April 30; an inventory increase of $16,000 is planned for May 31. All inventory is marked to sell at cost plus 50 percent. Estimated cash disbursements for selling and administrative expenses for the month...
Goldman has the following budget plans: Sales are budgeted at $440,000 for November, $420,000 for December,...
Goldman has the following budget plans: Sales are budgeted at $440,000 for November, $420,000 for December, and $410,000 for January. Collections are expected to be 65% in the month of sale and 35% in the month following the sale. The cost of goods sold is 80% of sales. The company would like to maintain ending merchandise inventories equal to 70% of the next month's cost of goods sold. Payment for merchandise is made in the month following the purchase. Other...
Angela is worried about her labour costs. She budgeted that each of her products would take...
Angela is worried about her labour costs. She budgeted that each of her products would take 1.33 hours to complete at a rate of $26 per direct labour hour. This month, Angela’s business has produced 1,850 products. She has paid her workers a total of $55,500 in wages. Additionally, there is a 5% CPP expense which must also be paid (Angela includes this in her budgeting). Angela also gave a $500 bonus to all fourteen of her workers, since they...
Question 2: Budget (20 marks in total) Lulu Company has the following budgeted sales for the...
Question 2: Budget (20 marks in total) Lulu Company has the following budgeted sales for the next six-month period: Month Unit Sales January 48,000 February 84,000 March 60,000 April 72,000 May 48,000 June 80,000 There were 69,000 units of finished goods in inventory at the beginning of January. Plans are to have an inventory of finished products that equals 100% of the following month sales plus 25% of the second month sales. Two kilograms of raw materials are required for...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT