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 1 11,000 units Quarter 2 12,000 units Quarter 3 14,000 units Quarter 4 13,000 units Month 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 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: а. Prepare the sales budget of Bintang Berhad for each quarter of the upcoming year 2019. b. Prepare the production budget of Bintang Berhad for each quarter of the year 2019. Prepare the raw material budget in kgs and value of Bintang Berhad for each quarter of the year 2019. С.
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 1 11,000 units Quarter 2 12,000 units Quarter 3 14,000 units Quarter 4 13,000 units Month 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 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: а. Prepare the sales budget of Bintang Berhad for each quarter of the upcoming year 2019. b. Prepare the production budget of Bintang Berhad for each quarter of the year 2019. Prepare the raw material budget in kgs and value of Bintang Berhad for each quarter of the year 2019. С.
Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
ChapterC: Cases
Section: Chapter Questions
Problem 1C
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning