70.2K

Verified Solution

Link Copied!

V GROUP PROJECT[U] - Read-Only-Saved to my Mac yout References Mailings Review View Tell me 2 Anticipate BCD Aalbo click Duplicate Aliexpress mactares specific electrical products. The company is preparing detailed budgets for the third quarter and has embled the following information to win the bolig preparation: The Marketing Department is estimated sales as follows for the remainder of the years SO 63,700 Month July A Eeprember October November December 1.450 Shading 1% The wing price of each product is 518 per unit. All sales are an account Based past experience, als are collected in the following pattern 35 percent in the methode Sales for me toled SOO Cash balance en son is 59.000 The company maintains finished goods in 34.5% of the following wles. This requirement will be met at the end of me Each electrical product requires units of material that is sometimes hard to acquire Therefore, the company requires that the ending inventory of the material to be equal to 59% of the following med production. The inventory of www material on hand the beginning and end of the quarter will be June 30:4.900 Romaterial con la monthly prasowania i paid for the month of related is paid for the following the pa Jwly for purchases of raw material during June will be 578,000 Tada warto ited States Focus MacBook Air DU 80 13 DD 59 F 17 F VO 51 $ % & 3 4 50 6 1 7 V 8 A 9 9 0 Grade: ( %) (20 marks) GRADING RUBRIC: 100 marks 1. The concept of budgeting, objectives, procedure and benefits of budget 2. Sales Badget (5 marks) 3. Schedule of cash collection (14 marks) 4. Production budget (12 marks) 5. Material budget (15 marks) 6. Schedule of cash payment 14marks I 7. Cashbudget (10 marks) & Advice (5marks) Shading 9. Presentation and referencing (5 m Questions to answer 1. Explain the concept of Budgeting in detail, highlighting the objectives procedure and benefits of preparing budget 2. From the case scenario given below you are required to 1 Prepare a sales budget, by month and in total, for the third quarter (Show your budget in both units and dollars.) Also prepare a schedule of expected cash collections, by month and in total, for the third quarter. II. Prepare a production budget for each of the months July October IIL Prepare a direct materials budget, by month and in total for the third quarter. IV Prepare a schedule of expected cash disbursements for raw material, by month and in total, for the third quarter V. Prepare a cash budget by month and in total for the third quarter VI Based on the budgets you have prepared above, what advice do you have for the management of Aliexpress? Submission method: One soft copy on BBL to be submitted for each group no later than 2pm on 24 June 2020. Late submission will be penalized Focus MacBook Air 80 DOO 000 DII FB 3 F4 F5 F6 F7 F9 F10 & Snapchat. 43% 12:12 PM GROUP PROJECT[1] DOCX - 36 KB 49,500 83.700 Case scenario: Aliexpress manufactures specific electrical products. The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation: The Marketing Department has estimated sales as follows for the remainder of the year (in units): Months Sales in units July August September 66,350 October 4,450 November 25,480 December 26,225 The selling price of each product is $18 per unit. All sales are on account. Based on past experience, sales are collected in the following pattern: 35 percent in the month of sale 55 percent in the month following sale 5 percent uncollective Sales for June totaled $380,500 Cash balance on 30 June is $9,000 The company maintains finished goods inventories equal to 24.5% of the following month's sales. This requirement will be met at the end of June. Each electrical product requires 4.6 units of raw material that is sometimes hard to acquire. Therefore, the company requires that the ending inventory of the raw material to be equal to 55% of the following month's production needs. The inventory of raw material on hand at the beginning and end of the quarter will be: June 30: 34,900 units Raw material costs 80.71 per unit. One-half of a month's purchases of raw material is paid for in the month of purchase: the remainder is paid for in the following month. The accounts payable on July 1 for purchases of raw material during June will be $78,000 End of case scenario Page 3 of 3 Open Word Snapchat . 43% 12:12 PM GROUP PROJECT[1] DOCX - 36 KB Grade: GRADING RUBRIC: 100 marks 1. The concept of budgeting, objectives, procedure and benefits of budget (20 marks) 2. Sales Budget (5 marks) 3. Schedule of cash collection (14 marks) 4. Production budget (12 marks) 5. Material budget (15 marks) 6. Schedule of cash payment = 14marks 7. Cash budget (10 marks) 8. Advice (5marks) 9. Presentation and referencing (5 marks) Questions to answer 1. Explain the concept of Budgeting in detail, highlighting the objectives procedure and benefits of preparing budget. 2. From the case scenario given below you are required to: 1. Prepare a sales budget, by month and in total, for the third quarter. (Show your budget in both units and dollars.) Also prepare a schedule of expected cash collections, by month and in total, for the third quarter. II. Prepare a production budget for each of the months July-October III. Prepare a direct materials budget, by month and in total, for the third quarter. IV. Prepare a schedule of expected cash disbursements for raw material, by month and in total, for the third quarter V. Prepare a cash budget by month and in total for the third quarter VI. Based on the budgets you have prepared above, what advice do you have for the management of Aliexpress? Submission method: One soft copy on BBL to be submitted for each group no later than 2pm on 24 June, 2020. Late submission will be penalized. 3 Open Word Aliexpress manufactures specific electrical products. The company is preparing detailed budgets for the third quarter and V GROUP PROJECT[U] - Read-Only-Saved to my Mac yout References Mailings Review View Tell me 2 Anticipate BCD Aalbo click Duplicate Aliexpress mactares specific electrical products. The company is preparing detailed budgets for the third quarter and has embled the following information to win the bolig preparation: The Marketing Department is estimated sales as follows for the remainder of the years SO 63,700 Month July A Eeprember October November December 1.450 Shading 1% The wing price of each product is 518 per unit. All sales are an account Based past experience, als are collected in the following pattern 35 percent in the methode Sales for me toled SOO Cash balance en son is 59.000 The company maintains finished goods in 34.5% of the following wles. This requirement will be met at the end of me Each electrical product requires units of material that is sometimes hard to acquire Therefore, the company requires that the ending inventory of the material to be equal to 59% of the following med production. The inventory of www material on hand the beginning and end of the quarter will be June 30:4.900 Romaterial con la monthly prasowania i paid for the month of related is paid for the following the pa Jwly for purchases of raw material during June will be 578,000 Tada warto ited States Focus MacBook Air DU 80 13 DD 59 F 17 F VO 51 $ % & 3 4 50 6 1 7 V 8 A 9 9 0 Grade: ( %) (20 marks) GRADING RUBRIC: 100 marks 1. The concept of budgeting, objectives, procedure and benefits of budget 2. Sales Badget (5 marks) 3. Schedule of cash collection (14 marks) 4. Production budget (12 marks) 5. Material budget (15 marks) 6. Schedule of cash payment 14marks I 7. Cashbudget (10 marks) & Advice (5marks) Shading 9. Presentation and referencing (5 m Questions to answer 1. Explain the concept of Budgeting in detail, highlighting the objectives procedure and benefits of preparing budget 2. From the case scenario given below you are required to 1 Prepare a sales budget, by month and in total, for the third quarter (Show your budget in both units and dollars.) Also prepare a schedule of expected cash collections, by month and in total, for the third quarter. II. Prepare a production budget for each of the months July October IIL Prepare a direct materials budget, by month and in total for the third quarter. IV Prepare a schedule of expected cash disbursements for raw material, by month and in total, for the third quarter V. Prepare a cash budget by month and in total for the third quarter VI Based on the budgets you have prepared above, what advice do you have for the management of Aliexpress? Submission method: One soft copy on BBL to be submitted for each group no later than 2pm on 24 June 2020. Late submission will be penalized Focus MacBook Air 80 DOO 000 DII FB 3 F4 F5 F6 F7 F9 F10 & Snapchat. 43% 12:12 PM GROUP PROJECT[1] DOCX - 36 KB 49,500 83.700 Case scenario: Aliexpress manufactures specific electrical products. The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation: The Marketing Department has estimated sales as follows for the remainder of the year (in units): Months Sales in units July August September 66,350 October 4,450 November 25,480 December 26,225 The selling price of each product is $18 per unit. All sales are on account. Based on past experience, sales are collected in the following pattern: 35 percent in the month of sale 55 percent in the month following sale 5 percent uncollective Sales for June totaled $380,500 Cash balance on 30 June is $9,000 The company maintains finished goods inventories equal to 24.5% of the following month's sales. This requirement will be met at the end of June. Each electrical product requires 4.6 units of raw material that is sometimes hard to acquire. Therefore, the company requires that the ending inventory of the raw material to be equal to 55% of the following month's production needs. The inventory of raw material on hand at the beginning and end of the quarter will be: June 30: 34,900 units Raw material costs 80.71 per unit. One-half of a month's purchases of raw material is paid for in the month of purchase: the remainder is paid for in the following month. The accounts payable on July 1 for purchases of raw material during June will be $78,000 End of case scenario Page 3 of 3 Open Word Snapchat . 43% 12:12 PM GROUP PROJECT[1] DOCX - 36 KB Grade: GRADING RUBRIC: 100 marks 1. The concept of budgeting, objectives, procedure and benefits of budget (20 marks) 2. Sales Budget (5 marks) 3. Schedule of cash collection (14 marks) 4. Production budget (12 marks) 5. Material budget (15 marks) 6. Schedule of cash payment = 14marks 7. Cash budget (10 marks) 8. Advice (5marks) 9. Presentation and referencing (5 marks) Questions to answer 1. Explain the concept of Budgeting in detail, highlighting the objectives procedure and benefits of preparing budget. 2. From the case scenario given below you are required to: 1. Prepare a sales budget, by month and in total, for the third quarter. (Show your budget in both units and dollars.) Also prepare a schedule of expected cash collections, by month and in total, for the third quarter. II. Prepare a production budget for each of the months July-October III. Prepare a direct materials budget, by month and in total, for the third quarter. IV. Prepare a schedule of expected cash disbursements for raw material, by month and in total, for the third quarter V. Prepare a cash budget by month and in total for the third quarter VI. Based on the budgets you have prepared above, what advice do you have for the management of Aliexpress? Submission method: One soft copy on BBL to be submitted for each group no later than 2pm on 24 June, 2020. Late submission will be penalized. 3 Open Word Aliexpress manufactures specific electrical products. The company is preparing detailed budgets for the third quarter and

Answer & Explanation Solved by verified expert

See Answer