Bintang Berhad manufactures Product BFF and it was sold in the market at the price of RM18 per unit. The marketing department of Bintang Berhad has submitted the following sales forecast for the upcoming year 2019 as follows: Month Sales Demand Quarter 1 11,000 units Quarter 2 12,000 units Quarter 3 14,000 units Quarter 4 13,000 units The company expects to start the first quarter with 1,650 units in finished goods inventory. It is the company's policy to hold stocks of finished goods at the end of each quarter equals to 15% of the next quarter's budgeted sales. The desired ending finished goods inventory for the fourth quarter is 1,850 units. The beginning raw materials inventory for the first quarter is budgeted to be 1,400 kg. Each unit of Product BFF requires 2 kg of raw material that costs RM1.40 per kg. The management's policy is to hold ending inventory of raw materials equal to 10% of the following quarter's production needs. The desired ending raw material inventory for the fourth quarter is 1,500 units. In addition, the labour is paid at RM14.00 per hour and each unit Product BFF requires 0.60 direct labour hours. Required:

Bintang Berhad manufactures Product BFF and it was sold in the market at the price of RM18 per unit. The marketing department of Bintang Berhad has submitted the following sales forecast for the upcoming year 2019 as follows: Month Sales Demand Quarter 1 11,000 units Quarter 2 12,000 units Quarter 3 14,000 units Quarter 4 13,000 units The company expects to start the first quarter with 1,650 units in finished goods inventory. It is the company's policy to hold stocks of finished goods at the end of each quarter equals to 15% of the next quarter's budgeted sales. The desired ending finished goods inventory for the fourth quarter is 1,850 units. The beginning raw materials inventory for the first quarter is budgeted to be 1,400 kg. Each unit of Product BFF requires 2 kg of raw material that costs RM1.40 per kg. The management's policy is to hold ending inventory of raw materials equal to 10% of the following quarter's production needs. The desired ending raw material inventory for the fourth quarter is 1,500 units. In addition, the labour is paid at RM14.00 per hour and each unit Product BFF requires 0.60 direct labour hours. Required:

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

ChapterC: Cases

Section: Chapter Questions

Problem 1C

See similar textbooks

Similar questions

Bintang Berhad manufactures Product BFF and it was sold in the market at the price of RM18 per unit. The marketing department of Bintang Berhad has submitted the following sales forecast for the upcoming year 2019 as follows: Quarter 2 12,000 units Quarter 3 14,000 units Quarter 4 13,000 units Month Quarter 1 11,000 units Sales Demand The company expects to start the first quarter with 1,650 units in finished goods inventory. It is the company's policy to hold stocks of finished goods at the end of each quarter equals to 15% of the next quarter's budgeted sales. The desired ending finished goods inventory for the fourth quarter is 1,850 units. The beginning raw materials inventory for the first quarter is budgeted to be 1,400 kg. Each unit of Product BFF requires 2 kg of raw material that costs RM1.40 per kg. The management's policy is to hold ending inventory of raw materials equal to 10% of the following quarter's production needs. The desired ending raw material inventory for the…
ABC PLC produces and sells a branded product. The following productions and sales forecasts for the month of June, July, August and September 2020 were extracted from the records of the company: June July August September Purchases (in units) 8,000 12,000 15,000 13,000 Sales (in units) 9,000 10,000 14,000 13,000 The following additional information is also provided: Purchase price per unit is Rs.80. All the purchases are made on credit basis and payments will be made in the following month. 60% of the sales are on cash basis and balance will be collected in the following month. Selling price per unit is Rs.120. Total administration and distribution expenses for the month have been estimated to be Rs. 480,000 and it will be paid in the same month. The company intends to obtain a bank loan of Rs. 1,000,000 during the month of August 2020 to be settled in monthly installments of Rs. 60,000 each for a period of 2 years. First installment will…
Wildhorse Ltd. estimates sales for the second quarter of 2022 will be as follows. Month April May June Units March 31 April 30 May 31 June 30 3,090 3,190 2,960 The target ending inventory of finished products is as follows. 2,440 2,620 2,600 2,900 Two units of materials are required for each unit of finished product. Production for July is estimated at 3,210 units to start building inventory for the fall sales period. Wildhorse's policy is to have an inventory of raw materials at the end of each month equal to 50% of the following month's production requirements. Raw materials are expected to cost $4 per unit throughout the period. Calculate the May raw materials purchases in dollars. Raw material purchases cost
Fumiture, Inc., estimates the following number of mattress sales for the first four months of 2019 Month Sales 23,000 January February March 33,800 36,600 April 35,200 Finished goods inventory at the end of December is 6,800 units. Target ending finished goods inventory is 20% of the next month's sales How many mattresses should be produced in the first quarter of 2019?
Crane Ltd. estimates sales for the second quarter of 2022 will be as follows. Month Units April 3,190 May 3,290 June 3,060 The target ending inventory of finished products is as follows. March 31 2,520 April 30 2,700 May 31 2,680 June 30 3,000 Two units of materials are required for each unit of finished product. Production for July is estimated at 3,310 units to start building inventory for the fall sales period. Crane’s policy is to have an inventory of raw materials at the end of each month equal to 50% of the following month’s production requirements.Raw materials are expected to cost $4 per unit throughout the period.Calculate the May raw materials purchases in dollars.
Furniture, Inc., estimates the following number of mattress sales for the first four months of 2019: Month Sales January 32,000 February 36,800 March 29,600 April 43,200 Finished goods inventory at the end of December is 7,100 units. Target ending finished goods inventory is 20% of the next month's sales. Required: Calculate the How many mattresses should be produced in each month of the first quarter of 2019?
Victory Enterprise manufactures cabinets. Projected sales in units are as follows: October – 4.600 units; November – 5,000 units; December – 4,200 units; January – 6,000 units. The ending finished goods inventory for every month is projected to be at 50% of the sales in units of the next month. The number of units to be produced in December should be: 1. 3,000 units 2. 5,100 units 3. 4,200 units 4. 5,000 units Group of answer choices 1 2 3 4
pos Ibie Furniture, Inc., estimates the following number of mattress sales for the first four months of 2019: Month Sales January February 22,000 39,800 March 28,600 April 44,200 Finished goods inventory at the end of December is 6,900 units. Target ending finished goods inventory is 10% of the next month's sales. How many mattresses should be produced in the first quarter of 2019? A. 92,340 mattresses B. 68,840 mattresses TE O C. 87,920 mattresses 1 a O D. 57,760 mattresses Mi F Ju fir https: Cha The es sales 4 Missing Calculator Next http://mi tho ?3 O O O O
Osage Incorporated has actual sales for May and June and forecast sales for July, August, September, and October as follows: Actual: May June Forecast: July August 5,300 units 7,800 units September 5,900 units October 5,800 units 6,900 units 6,600 units Required: a. The firm's policy is to have finished goods inventory on hand at the end of the month that is equal to 50% of the next month's sales. It is currently estimated that there will be 2,650 units on hand at the end of June. Calculate the number of units to be produced in each of the months of July, August, and September. b. Each unit of finished product requires 8 pounds of raw materials. The firm's policy is to have raw material inventory on hand at the end of each month that is equal to 80% of the next month's estimated usage. It is currently estimated that 25,000 pounds of raw materials will be on hand at the end of June. Calculate the number of pounds of raw materials to be purchased in each of the months of July and August.…
Two products A and B are manufactured in a department. Sales for the year 2020 were planned as follows: Product Quarter 1 Quarter 2 Quarter 3 Quarter 4 8000 10000 11000 14000 6000 8000 7500 5500 Selling prices in Quarter 1 were estimated as OMR 20 per unit for A and OMR 30 for B respectively. Average sales return are 5% of Sales. According to these estimates, which of the following is estimated Sales (OMR) in Quarter 3 for Product A?
Shadee Corporation expects to sell 500 sun shades in May and 440 in June. Each shades sells for $19. Shadee's beginning and ending finished goods inventories for May are 75 and 45 shades, respectively. Ending finished goods inventory for June will be 70 shades. It expects the following unit sales for the third quarter: July August September 575 460 450 Sixty percent of Shadee's sales are cash. Of the credit sales, 54 percent is collected in the month of the sale, 39 percent is collected during the following month, and 7 percent is never collected. Required: Calculate Shadee's total cash receipts for August and September. Note: Do not round your intermediate calculations. Round your answers to the nearest whole dollar. Total Cash Receipts August September
Two products A and B are manufactured in a department. Sales for the year 2020 were planned as follows: Product Quarter 1 Quarter 2 Quarter 3 Quarter 4 8000 10000 11000 14000 B 6000 8000 7500 5500 Selling prices in Quarter 1 were estimated as OMR 20 per unit for A and OMR 30 for B respectively. Average sales return are 5% of Sales . According to these estimates, which of the following is estimated Sales (OMR) in Quarter 3 for Product A? Select one: O a. 185600 O b. 254050 O c. The correct answer not available O d. 209000 e. 219600