Required: 1. (10) Production and sales plans: (a) Prepare a 12 months production and sales plan...

Transcribed Image Text:

Required: 1. (10) Production and sales plans: (a) Prepare a 12 months production and sales plan table. You are required: i. Prepare the sales and production plan in unit and money measures; 12 Month Sales Plan Unit Jan 500 250 Feb 550 250 12 Month Production Plan - Jan 520 Feb 150 560 Mar 535 150 250 April 530 520 250 Mar Apr Sales Cost Gross profit May 525 490 250 June 500 510 150 150 150 250 July 550 250 150 Aug 600 250 150 100 250 Price (RM) Sales(RM) 125,000 137,500 133,750 130,000 122,500 127,500 137,500 150,000 151,250 145,000 150,000 155,000 1,665,000 May June July Aug Sep 505 555 600 Sep 605 250 150 150 610 Oct 150 580 Unit Cost per Unit (RM) Production 78,000 84,000 79,500 78,750 75,000 75,750 83250 90,000 91,500 87000 88,500 93000 998,986.25 costs(RM) 250 Nov 600 3000 1800 1200 250 Oct Nov Dec 150 150 580 590 620 (b) Present the sale price, production cost and gross profit for your product on a 'per unit' base and a 12 month base. Per unit (RM) 12 month (RM) Dec 150 620 250 Total 6.695 Total 6.660 1800 3000 Required: 1. (10) Production and sales plans: (a) Prepare a 12 months production and sales plan table. You are required: i. Prepare the sales and production plan in unit and money measures; 12 Month Sales Plan Unit Jan 500 250 Feb 550 250 12 Month Production Plan - Jan 520 Feb 150 560 Mar 535 150 250 April 530 520 250 Mar Apr Sales Cost Gross profit May 525 490 250 June 500 510 150 150 150 250 July 550 250 150 Aug 600 250 150 100 250 Price (RM) Sales(RM) 125,000 137,500 133,750 130,000 122,500 127,500 137,500 150,000 151,250 145,000 150,000 155,000 1,665,000 May June July Aug Sep 505 555 600 Sep 605 250 150 150 610 Oct 150 580 Unit Cost per Unit (RM) Production 78,000 84,000 79,500 78,750 75,000 75,750 83250 90,000 91,500 87000 88,500 93000 998,986.25 costs(RM) 250 Nov 600 3000 1800 1200 250 Oct Nov Dec 150 150 580 590 620 (b) Present the sale price, production cost and gross profit for your product on a 'per unit' base and a 12 month base. Per unit (RM) 12 month (RM) Dec 150 620 250 Total 6.695 Total 6.660 1800 3000

Answer rating: 100% (QA)

jan feb march april may june july aug sept oct nov dec In units opening inventory 20 30 25 30 40 35 40 40 45 45 35 production 520 560 530 525 500 505 ... View the full answer