Question: Required: Using the data given above, prepare the following detailed schedules along with other supportive schedules for the First quarter (JAN- FEB MARCH) of the

Required: Using the data given above, prepare the following detailed schedules along with other supportive schedules for the First quarter (JAN- FEB MARCH) of the year 2020. 1) Sales budget 2) Production budget 3) Production cost budget 4) Cash budget Supportive schedules a) Cash collection schedule b) Direct material schedule c) Direct labor schedule d) Variable manufacturing cost schedule.
Case study-1( 10 points) Prepare Master Budget Dallah Al-Baraka Group's newly hired accountant has persuaded management to prepare a master budget to aid financial and operating decisions. Sales in December (2019) were 4000 units @ sar10 per unit. Monthly sales for the first four months of the next year (2020) are forecasted as follows: Months units January 5,000 February 8,000 March 6, 000 April 5,000 Unit selling price SAR 10 The following information given to you as follows: 1) Normally 60% of sales are collected in the month incurred and the remainders are collected in the month following the sales. 2) Dallah groups wants closing stock equals 10% of the following month's budgeted sales in units. on December 31 st, 400 units were on hand. 3) Material required for the required production units are 3,500 Mts, 4,500 Mts., and 6,500 Mts. Respectively for the month of January, February and march Respectively. The cost of 1 Mts of material is SAR 10. 4) 1 Labor hour will be taken for each unit of production and labor cost per hour is SAR 2 5) Unit Variable manufacturing overhead is SAR 3 and fixed manufacturing overhead cost is SAR 1,000 for every month. 6) The cash balance as on December 2019 is SAR 100,000
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
