GGG Company Assume that the firm is expecting to have the following quarterly unit sales with a price of P85: First Quarter Second Quarter 5,500 Third Quarter Fourth Quarter 5,000 6,000 6,500 50% of which are collected at the same month and the remaining 30% will be collected next quarter and the 20% on the next 2 quarters. Assume further that their ending inventory will be 25% of the next quarter's units and for the fourth quarter they had 1,300 units left. There is an accounts receivable recorded amounting to P350,000 GGG Company Sales Budget For the Year Ended December 31, 2022 Quarter 2 5,500 85 467,500 1 5,000 85 425,000 3 6,000 85 510,000 Total 23,000 85 1,955,000 Expected sales in units Unit Sales Price 6,500 85 Total Sales 552,500 Schedule of Expected Cash Collections 2 Total Accounts Reccivable P350,000 P350,000 First Quarter 1. Second Quarter Third Quarter Fourth Quarter 85,000 233,750 2. 3. 127,500 4. 5. 6. 7. 93,500 153,000 276,250 P522,750 Total Cash Collection 8. P361,250 9. 10.

GGG Company Assume that the firm is expecting to have the following quarterly unit sales with a price of P85: First Quarter Second Quarter 5,500 Third Quarter Fourth Quarter 5,000 6,000 6,500 50% of which are collected at the same month and the remaining 30% will be collected next quarter and the 20% on the next 2 quarters. Assume further that their ending inventory will be 25% of the next quarter's units and for the fourth quarter they had 1,300 units left. There is an accounts receivable recorded amounting to P350,000 GGG Company Sales Budget For the Year Ended December 31, 2022 Quarter 2 5,500 85 467,500 1 5,000 85 425,000 3 6,000 85 510,000 Total 23,000 85 1,955,000 Expected sales in units Unit Sales Price 6,500 85 Total Sales 552,500 Schedule of Expected Cash Collections 2 Total Accounts Reccivable P350,000 P350,000 First Quarter 1. Second Quarter Third Quarter Fourth Quarter 85,000 233,750 2. 3. 127,500 4. 5. 6. 7. 93,500 153,000 276,250 P522,750 Total Cash Collection 8. P361,250 9. 10.

Intermediate Financial Management (MindTap Course List)

13th Edition

ISBN:9781337395083

Author:Eugene F. Brigham, Phillip R. Daves

Publisher:Eugene F. Brigham, Phillip R. Daves

Chapter22: Providing And Obtaining Credit

Section: Chapter Questions

Problem 4MC

See similar textbooks

Similar questions

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.
Lewellen Products has projected the following sales for the coming year: 01 02 03 04 Sales $940 $1,020 $980 $1,080 Sales in the year following this one are projected to be 20 percent greater in each quarter a. Calculate payments to suppliers assuming that the company places orders during each quarter equal to 30 percent of projected sales for the next quarter. Assume that the company pays immediately. What is the payables period in this case? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) b. Calculate payments to suppliers assuming a 90-day payables period. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) c. Calculate payments to suppliers assuming a 60-day payables period. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) a. b. Payment of accounts Payment of accounts Payment of accounts 01 02 Q3 Q4
For the first quarter of 2021, the target sales amount to 500,000 units. For the months of January, February and March,these sales be spread at 25%, 30% and 45% respectively. The cost per unit would be P200. It is the policy of the firm to maintain 20%of the next month’s sales as ending inventory of the current month. The beginning balance of the year for inventories and accountspayable are P5,000,000 (25,000 units at P200/unit) and P20,000,000 respectively. The payables are to be fully paid in January. Thebudgeted sales for April is 240,000 units. Only 20% of payables are paid during the month of purchase with the remaining settled inthe month after purchase. Find the budgeted cost of sales, targeted ending inventory balance required purchases and targeted ending accounts payable for the month of January, February and March January February March Budgeted Cost of Sales Targeted Ending Inventory Balance Required Purchaes Targeted Ending Accounts Payable…
Yanimize company sales in December 2018 were $70,000 and they are expected to rise by $4,500 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 forty 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,000, rent and heating $700 and depreciation $600. A machine is to be bought in March for $5,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 $14,400. 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 $8,000; prepare a cash budget for the two months ending March 31,…
UM Berhad has projected sales for the first six months of 2020 as follows: Month RM January 100,000 February 120,000 March 150,000 April 300,000 May 275,000 June 200,000 Of the firm’s sales, 50% is collected in the month of sale, 25% one month after sales and the remaining 25% two months after sales. UMCCED Berhad purchases raw materials equal to 70% of sales and it makes its purchases one month in advance of sales. The supplier is paid one month after the purchases. The firm incurs and pays a monthly rent expense of RM3,000. General and administrative expenses of RM20,000 are recognised and are paid monthly. Tax prepayments of RM22,000 are made each quarter beginning in March. The firm’s ending cash balance as at 28 February 2020 was RM30,000. Required: Prepare a monthly cash budget for March until May 2020.
Hammond Supplies expects sales of 235,880 units per year with carrying costs of $2.18 per unit and ordering cost of $3.1 per order. Assuming the level of inventory is stable, what is the optimal average number of units in inventory? Round to the nearest whole number.
Paymore Products places orders for goods equal to 75% of its sales forecast in the next quarter. What will orders be in each quarter of the year if the sales forecasts for the next five quarters are as follows: Quarter in Coming Year Following Year First Second Third Fourth First Quarter Sales forecast $ 372 $ 360 $ 336 $ 384 $ 384
NuParts, Inc., has estimated quarterly sales for next year, starting with Quarter 1, of $15,900, $16,800, $17,500, and $16,400. Purchases are equal to 67 percent of the following quarter's sales and the accounts payable period is 60 days. Assume 30 days in each month. How much will the firm owe its suppliers at the end of Quarter 3? $7,066.67 $7,506.67 $7,816.67 $6,933.33 $7,325.33
Ivanhoe Company produces and sells automobile batteries, the heavy-duty HD-240. The 2022 sales forecast is as follows. Quarter HD-240 1 4,300 2 6,020 3 4 6,880 8,600 The January 1, 2022, inventory of HD-240 is 1,720 units. Management desires an ending inventory each quarter equal to 40% of the next quarter's sales. Sales in the first quarter of 2023 are expected to be 25% higher than sales in the same quarter in 2022. Prepare quarterly production budgets for each quarter and in total for 2022.
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.
Swansong plans to sell 10,000 units of a particular product during July, and expects sales to increase at the rate of 10% per month during the remainder of the year. The June 30 and September 30 ending inventories are anticipated to be 950 units and 1,100 units, respectively. On the basis of this information, how many units should Swansong purchase for the quarter ended September 30? Select one: a. 34,750 units b. 31,850 units c. 33,250 units d. 32,950 units
Crane Company produces and sells automobile batteries, the heavy-duty HD-240. The 2022 sales forecast is as follows. Quarter HD-240 1 2 3 4 6,300 8,820 10,080 12,600 The January 1, 2022, inventory of HD-240 is 2,520 units. Management desires an ending inventory each quarter equal to 40% of the next quarter's sales. Sales in the first quarter of 2023 are expected to be 25% higher than sales in the same quarter in 2022. Prepare quarterly production budgets for each quarter and in total for 2022.