Sunlight Company forecasts purchases of 30,000 widgets in June. It sells the widget at $14.00 per unit. The company has 2,500 units on hand on June 1. The desired ending inventory of widgets on June 30 is to be 10% lower than the beginning inventory. Total June sales for widgets are anticipated to be (in dollars):

Sunlight Company forecasts purchases of 30,000 widgets in June. It sells the widget at $14.00 per unit. The company has 2,500 units on hand on June 1. The desired ending inventory of widgets on June 30 is to be 10% lower than the beginning inventory. Total June sales for widgets are anticipated to be (in dollars):

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter7: Budgeting

Section: Chapter Questions

Problem 4EA: One Device makes universal remote controls and expects to sell 500 units in January, 800 in...

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?
If the sales forecast estimates that 50,000 units of product will be sold during the following year, should the factory plan on manufacturing 50,000 units in the coming year? Explain.
One Device makes universal remote controls and expects to sell 500 units in January, 800 in February, 450 in March, 550 in April, and 600 in May. The required ending inventory is 20% of the next months sales. Prepare a production budget for the first four months of the year.
Ranger Industries has provided the following information at June 30: Other information: Average selling price, 196 Average purchase price per unit, 110 Desired ending inventory, 40% of next months unit sales Collections from customers: In month of sale20% In month after sale50% Two months after sale30% Projected cash payments: Inventory purchases are paid for in the month following acquisition. Variable cash expenses, other than inventory, are equal to 25% of each months sales and are paid in the month of sale. Fixed cash expenses are 40,000 per month and are paid in the month incurred. Depreciation on equipment is 2,000 per month. REQUIREMENT You have been asked to prepare a master budget for the upcoming quarter (July, August, and September). The components of this budget are a monthly sales budget, a monthly purchases budget, a monthly cash budget, a forecasted income statement for the quarter, and a forecasted September 30 balance sheet. The worksheet MASTER has been provided to assist you. Ranger Industries desires to maintain a minimum cash balance of 8,000 at the end of each month. If this goal cannot be met, the company borrows the exact amount needed to reach its goal. If the company has a cash balance greater than 8,000 and also has loans payable outstanding, the amount in excess of 8,000 is paid to the bank. Annual interest of 18% is paid on a monthly basis on the outstanding balance.
Cash collections for Renew Lights found that 65% of sales were collected in the month of sale, 25% was collected the month after the sale, and 10% was collected the second month after the sale. Given the sales shown, how much cash will be collected in March and April?
Cash collections for Wax On Candles found that 60% of sales were collected in the month of the sale, 30% was collected the month after the sale, and 10% was collected the second month after the sale. Given the sales shown, how much cash will be collected in January and February?
Croy Inc. has the following projected sales for the next five months: Month Salen in Unita 3,850 3,875 4, 260 4,135 3,590 April May June July August Croy's finished goods inventory policy is to have 60 percent of the next month's sales on hand at the end of each month, Direct materials cost $3.10 per pound, and each unit requires 2 pounds. Direct materials inventory policy is to have 50 percent of the next month's production needs on hand at the end of each month. Direct materials on hand at March 31 totaled 3,865 pounds. Required: 1. Determine budgeted production for April, May, and June. 2. Determine budgeted cost of materials purchased for April and May.
Shadee Corp. expects to sell 570 sun visors in May and 310 in June. Each visor sells for $15. Shadee's beginning and ending finished goods inventories for May are 60 and 40 units, respectively. Ending finished goods inventoryfor June will be 65 units. It expects the following unit sales for the third quarter. July: 575 August: 440 September: 420 Sixty percent of Shadee's sales are cash. Of the credit sales, 52 percent is collected in the month of the sale, 39 percent is collected during the following month, and 9 percent is never collected. Calculate Shadee's total cash receipots for August and September?
Croy Inc. has the following projected sales for the next 5 months: Month Sales in Units April 3,430 May 3,875 June 4,570 July 4,140 August 3,910 Croys finished goods inventory Policy is to have 50 percent of next month's sales on hand at the end of each month. Direct materials cost $2.80 per pound, and each unit requires 2 pounds. Direct materials inventory policy is to have 50 percent of the next month's production needs on hand at the end of each month. Direct materials on hand at March 31 totaled 3,653 pounds. 1. Determine Budgeted production for April, May, and June. April?Beginning inventory. May =4,222.5 June 4,355 2. Determine budgeted cost of materials purchsed for April and May.
Austin Computers company sales in December 2018 were $80,000 and they are expected to rise by $5,000 per month for the next 5 months. Of sales, 80 per cent are collected during the month of sale and the rest two months after sales. The cost of sales is 60 per cent of sales and, the company plans to keep an inventory at the end of each month equal to 40 per cent of the anticipated sales for the next month’s sales. Suppliers are paid one month after purchases are made. Monthly wages amount to $4,500, rent and heating $750 and depreciation $600. A machine is to be bought in March for $6,000 paid in cash. The purchase of the machine means that the monthly change for depreciation will increase by $40. The inventory held at January 1st is $15,500. Required: Calculate the estimated cash collection from sales for February and March. Calculate the purchases for February and March. Assuming that the cash balance at 31/01/2019 is $10,000; prepare a cash budget for the two months ending March…
Shadee Corp. expects to sell 550 sun visors in May and 310 in June. Each visor sells for $16. Shadee’s beginning and ending finished goods inventories for May are 65 and 45 units, respectively. Ending finished goods inventory for June will be 65 units. It expects the following unit sales for the third quarter: July 530 August 450 September 450 Sixty percent of Shadee’s sales are cash. Of the credit sales, 52 percent is collected in the month of the sale, 38 percent is collected during the following month, and 10 percent is never collected. Required: Calculate Shadee’s total cash receipts for August and September.
Croy Inc. has the following projected sales for the next five months: Month Sales in Units April 3,850 May 3,875 June 4,260 July 4,135 August 3,590 Croy’s finished goods inventory policy is to have 60 percent of the next month’s sales on hand at the end of each month. Direct materials cost $3.10 per pound, and each unit requires 2 pounds. Direct materials inventory policy is to have 50 percent of the next month’s production needs on hand at the end of each month. Direct materials on hand at March 31 totaled 3,865 pounds. Required: 1. Determine budgeted production for April, May, and June.2. Determine budgeted cost of materials purchased for April and May.