Production and Sales Plan Question

Your answers should be based on the scenario of a new business called MIKE SPORT SHOES SDN BHD.

MIKE SPORT SHOES SDN BHD has recently developed a new technology to make shoes more breathable and long lasting. The company is based in Selangor and has 100 employees. The shoes are being sold at RM 250 per pair and its cost price is RM 150.

Required: 1. Production and sales plans (a) Prepare a 12 months production and sales plantable. You are required Prepare the sales and production plan in unit and money treasures , 12 Month Sales Plan Jan Feb Mar April May June Aug Sep Oct Nov Dec Total July 550 Unit 500 650 535 520 490 510 600 606 580 600 620 8,860 250 250 250 250 250 250 250 250 250 250 250 250 3000 Price (RM) Sales RM125,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 12 Month Production Plan- Jam Feb Mar Apr May June July Aug Sup Od Nav Dac Total Unit 520 580 530 525 500 505 555 500 610 5B0 590 620 8.695 Cost per 150 150 150 150 150 150 150 150 150 150 150 150 1800 Unit (RM) Production 78.000 84.000 79,50078,750 75.000 75.750 83250 90,000 91,500 87000 88,500 93000 998,986 25 costs(RM ) (t) Present the sale price, production cost and gross profit for your product on a per unit' base and a 12 month base Par unit (RMI 12 month(RM 250 Sales Cost 3000 1800 150 Gross pront 10x1 1200 (10% of the mark) 2 2 Cash budget: Prepare a Cash Budget (month by month) with below fomat. Note the following: Cash sales is 30% and credit sales is 20% to be received 1 month later ii. Cash purchases is 70% and credit purchases is 30% to be received 1 month later Will All expenses is expected to increase by 10% every 3 months IV MIKE SPORT SHOES SON BHD is planning to buy a machine in January worth RM 230,000 and a vehicle in March for RM 60,000 using cash V. The owner will put in RM 350.000 in the bank in January to start the business i. The owner is planning to withdraw monthly RM500 to pay his personal expenses starting in March. Jan-Dec 2021 FUL Mar AN Jan May ME Jun Jul A Out hov No DNE Total RM RECEIPTS Cash Sale! Credit Sales Capital 2.000 1980 TOTAL RECEIPTS (A) PAYMENTS Cash Purchases Credit Purchases Transport charges Fixed Asset Purchase Rent Rates Insurance Utilities Telephone Wagas Forlait rental Advertising Drawings TOTAL PAYMENTS (B) NET CASHFLOW (A-B) Bal Bank CVBal Bank 1,000 2500 500 1 2000 1,050 250 III 0