The sales budget (in units) of LIVES Inc. for the period January to June 2021 is as follows: January: 70,000 February: 80,000 March: 8O,000 April: 90,000 May: 90,000 June: 100,000 The firm's policy is maintain inventory at end of each month equal to 60% of sales for the month following. Sales are expected to decrease by 15% during July 2021. What is the total budgeted production in units for the 3 months period ending June 30, 2021?

The sales budget (in units) of LIVES Inc. for the period January to June 2021 is as follows: January: 70,000 February: 80,000 March: 8O,000 April: 90,000 May: 90,000 June: 100,000 The firm's policy is maintain inventory at end of each month equal to 60% of sales for the month following. Sales are expected to decrease by 15% during July 2021. What is the total budgeted production in units for the 3 months period ending June 30, 2021?

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter8: Budgeting For Planning And Control

Section: Chapter Questions

Problem 34E: A companys sales for the coming months are as follows: About 20 percent of sales are cash sales, and...

See similar textbooks

Similar questions

The sales department of Macro Manufacturing Co. has forecast sales for its single product to be 20,000 units for June, with three-quarters of the sales expected in the East region and one-fourth in the West region. The budgeted selling price is 25 per unit. The desired ending inventory on June 30 is 2,000 units, and the expected beginning inventory on June 1 is 3,000 units. Prepare the following: a. A sales budget for June. b. A production budget for June.
Shalom Company prepared the following sales budget for the first two quarters of 2023: January February March April 10,000 14,000 11,000 15,000 May 18,000 June 20,000 Unit sales Shalom Company sells the product at P15 per unit. 20% of sales is cash, and the balance is on credit. The company estimates that collection of sales on account will be 60% in the month of sales with the remainder in the following month. On December 31, 2022, accounts receivable was P60,000. Amounts must be in whole numbers. Example: 88,000 or (88,000) How much is the expected total cash receipts for January?
Hayma Company's sales budget for 2022 in units for the next five months is as follows: January 20,000, February 26,000, March 32,000, April 40,000 and May 42,000. The Company's ending finished goods inventory policy is set for 25% of the following month's sales. January 1 beginning inventory is 2,800 units. How many units will be produced in January? Ru O a. 40,500 O b. 16,300 1 Oc. None of the given answers. O d. 34,000 O e. 23,700 O f. 27,500
The budgeted transactions of Beacon Limited for the quarter ending 31 December 2021 are as follows: Budgeted total sales amount to R546 000. (25% will be sold during October, 40% during November and the rest during December) 75% of all sales are expected to be on credit. Debtors are expected to pay their debts as follows: 60% in the month following the month of the sale 25% in the second month following the month of the sale 10% in the third month following the month of the sale 5% is written off as irrecoverable Actual total sales for the quarter ending 30 September 2021 were as follows: July R66 000 August R96 000 September R132 000 REQUIRED Prepare a schedule showing the total budgeted amounts which Beacon Limited expects to receive from debtors during each month from 1 October 2021 to 31 December 2021
Hayma Company's sales budget for 2022 in units for the next five months is as follows: January 20,000, February 26,000, March 32,000, April 40,000 and May 42,000. The Company's ending finished goods inventory policy is set for 25% of the following month's sales. January 1 beginning inventory is 2,800 units. How many units will be produced in March? O a. 27,500 O b. 30,000 Oc. 24,700 O d. None of the given answers. O e. 40,500 O f. 34,000 Company XYZ produces and sells wireless earphones. The selling price per unit is $5 and the total fixed costs are $20,000. Assuming a variable cost ratio of 70%, what is the breakeven point in ($) value? (round figures to the nearest number) on Finis
Hayma Company's sales budget for 2022 in units for the next five months is as follows: January 20,000, February 26,000, March 32,000, April 40,000 and May 42,000. The Company's ending finished goods inventory policy is set for 25% of the following month's sales. January 1 beginning inventory is 2,800 units. How many units will be produced in March? O a. 34,000 O b. 24,700 O c. 40,500 O d. 30,000 O e. None of the given answers. O f. 27,500
Anderson Manufacturing Inc., aims to prepare a cash budget for September 2020. The cash balance at the beginning of September is $9,000. The actual sales for July and August and expected sales for September are: Information Cah Sales Sales on Accoun 0000 60,00 Tetal Sales July (5 Augut (5) Septemberis 14,300 Sales on account are collected over a three-month period in the following ratio: 10% in the month of sale, 70% in the month following sale 18% in the second month following sale 2% remaining are uncollectible. Additional information includes: (a) Purchases of inventory will total S 50,000 for September; 20% will be paid for in September. Accounts payable from August's inventory purchases is $ 32,000, all of which will be paid in September. (b) Selling and administrative expenses are budgeted at $ 26,000 for September; of which $ 8,000 is for depreciation. (c) Equipment costing $ 36,000 will be purchased for cash during September, and other miscellancous cash expenses of $ 6,000…
Shalom Company prepared the following sales budget for the first two quarters of 2023: January February March April May June 7,000 7,500 8,300 Unit sales 6,000 8,500 7,800 Shalom Company sells the product at P20 per unit. 20% of sales is cash, and the balance is on credit. The company estimates that collection of sales on account will be 60% in the month of sales with the remainder in the following month. In December 2022, total sales were P125,000. Amounts must be in whole numbers. Example: 88,000 or (88,000) 1. What is the balance of the accounts receivable on January 1, 2023? 2. How much is the expected total cash receipts for January? 3. How much is the expected total cash receipts for February? 4. How much is the expected total cash receipts for March? Item 1 Item 2 Item 3 Item 4
Sheldon Industries' sales budget shows quarterly sales for 2020 as follows: Quarter First Second Third Sales (Units) 10,000 8,000 12,000 14,000 Fourth Company policy is to have a finished goods inventory at the end of each quarter equal to 20% of the next quarter's sales. Prepare a production budget for the second quarter, in good form.
Lea Company's sales budget shows the following projections for the year ending Dec. 31, 2021: First quarter 40,000 units Third quarter 50,000 units Second quarter 55,000 units Fourth quarter 45,000 units The quantity of finished goods inventory at the end of each quarter is equal to 40% of the next quarter's budgeted unit sales and is constantly being maintained. What is the total production budget in units for one year ending Dec. 31, 2021 assuming that the estimated sales in units on the first quarter of 2022 is 50,000
Below is the sales budget (in units) of ABS Co. for the second half of 2021: July: 100,000 August: 90,000 September: 90,000 October: 80,000 November: 70,000 December: 70,000. The company's projection is to have inventory on hand at end of each month equal to 70% of sales of next month. It is assumed that inventory at end of June 2021 will meet this requirement and that 80,000 units will be sold in Jan. 2022.What is the total production budget in units for the 6 months' period ending December 31,2021? 479,000 486,000 524,000 556,000
The total budgeted sales of Obaapa Ltd for April, the first month of the second quarter in 2021 were GHS950,000. Sales are expected to increase by GHS50,000 in each month. Cash sales for each month are GHS100,000 and the remaining are credit sales. All the products are sold at a mark up of the cost plus 25 per cent. On average, Obaapa Ltd collects 50 per cent of the credit sales in the month of sale and 45 per cent in the month following sales. The remainder is uncollectible. Determine the budgeted total cash receipt for each month of the second quarter of 2021 and the expected account receivables at the end of the quarter.