Klean Steppers A group of students at the University of Technology. Jamaica recently won an award in the annual UTech, a Business Model Competition for their invention, a white dirs-proof secaker for children in Kindergarten. This invention arose from complaints from parents about having to buy white sneakers for their child children for physical education that soils easily. As a result of the invention, the students decided to start a business, Klean Steppers to start production The sneakers have an innovative design and are made of a robust leather and cushioning material, which heightens the resistance to dirt and dust The following information was discussed at a meeting with the Klean Steppers team Sales and collections The secakers are designed for girls and boys. Details of selling prices and projected sales in pairs of sneakers for the four-month period are shown below. Type Selling price Girls Boys S2500 $2900 July 250 195 Months August September 290 320 230 280 October 190 160 It is expected that all sales will be on credit to department stores in Jamaica. It is estimated that 3076 of customers will pay within one month while the remaining customers will pay the month following sale. Production Production of sneakers will be based on sales demand. The company requires a closing inventory of 20% of the next month's budgeted sales in pairs of sneakers for girls and boys. There is no opening stock of inventory Direct Materials and Direct labour (a) The sneakers are made with special leather and specially treated rubber for the sole The materials and labour required to make cach pair of sneakers are as follows: Type of sneakers Leather Cushion Labour $370 per meter S220 per meter 300 per hour 0.6m 0.15m 15 minutes Boys 0.10m 12 minutes Girls 0.4m The company requires a closing inventory of 10% of raw material required for the following month's material needed. Thete was no opening stock of taw material. The company plans to have a closing inventory of leather of 6.2m and 13m ef cushioning material as at the 30 September 2 Materials are purchased from a company based in the Cayman Island. This supplier requires that 50% of the purchase total is paid for in cash with the order, and allows one month's credit for the remaining amount (b) In keeping with government requirements, biodegradable cardboard boxes will be used to package the sneakers. Each box will cost $28.50 per box. The company will buy the packaging materials from a Jamaican company for cash each month, (e) To make girls' sneakers, each unit requires 15 minutes of direct labour hours and to make boys' sneakers cach unit requires 12 minutes of direct labour hours. The company pays $340 per hour for cach direct labour hour. Labour costs are paid in the month incurred. Manufacturing Overheads (d) The following manufacturing overheads are budgeted for the quarter. Indirect material Indirect labour Other overhead Depreciation July $10,200 54.800 $3,100 SI.NO August $11.200 54,120 $2,400 S1,800 September SI 2.200 54.280 $2,700 $1,800 In addition to the above overheads the following costs will be incurred: (e) The company has signed a rental agreement for the production facility. The annual rental charge will be $360,000, which will be paid in equal monthly installments. A security deposit amounting to $25,000 must also be paid in July, (Other operating costs including power, insurance, and administration expenses, which must be paid monthly, are expected to be $95.600 for the year, Selling and administrative costs Marketing Companie The company will launch an advertising campaign using social media, television, radio, and newspaper. This will cost $13,600 for three-month period payable in equal instalments from July Stle.commission A 2% commission on projected sales in dollars will be payable for cash in the month incurred. Other selling and administrative expense Other selling and administrative expenses use the following cost function per quarter: y= $24,000 +62x, where x represents budgeted sales in units. Other information (g) The prize money of $500,000 will be introduced at the commencement of the company's operations and should be treated as a cash inflow (capital/investment by owners). Beginning cash balance is nil. (h) The closing inventory as at 30h of September is $28,200 (i.c., raw material closing inventory is $5,154 and finished goods inventory is $23,046). (1) Klean Steppers is seeking $1,000,000 loan from Development Bank of Jamaica to purchase a new equipment costing $216,000 and assist with the operating expenses for its first year of operation. Interest rate on the loan is 12%. The principal and interest will be repaid in 4 installments at the end of each quarter. VI. (16 marks) VIL (13 marks) Direct labour budget Manufacture overhead budget Selling and administrative budget Cash budget VIII. (16 marks) IX (31 marks) X Cost of Goods Sold Budget (quarter only) (5 marks) XI. Budgeted Income Statement (quarter only) (5 marks) XII. Budgeted Balance Sheet (quarter only) (12 marks) Klean Steppers A group of students at the University of Technology. Jamaica recently won an award in the annual UTech, a Business Model Competition for their invention, a white dirs-proof secaker for children in Kindergarten. This invention arose from complaints from parents about having to buy white sneakers for their child children for physical education that soils easily. As a result of the invention, the students decided to start a business, Klean Steppers to start production The sneakers have an innovative design and are made of a robust leather and cushioning material, which heightens the resistance to dirt and dust The following information was discussed at a meeting with the Klean Steppers team Sales and collections The secakers are designed for girls and boys. Details of selling prices and projected sales in pairs of sneakers for the four-month period are shown below. Type Selling price Girls Boys S2500 $2900 July 250 195 Months August September 290 320 230 280 October 190 160 It is expected that all sales will be on credit to department stores in Jamaica. It is estimated that 3076 of customers will pay within one month while the remaining customers will pay the month following sale. Production Production of sneakers will be based on sales demand. The company requires a closing inventory of 20% of the next month's budgeted sales in pairs of sneakers for girls and boys. There is no opening stock of inventory Direct Materials and Direct labour (a) The sneakers are made with special leather and specially treated rubber for the sole The materials and labour required to make cach pair of sneakers are as follows: Type of sneakers Leather Cushion Labour $370 per meter S220 per meter 300 per hour 0.6m 0.15m 15 minutes Boys 0.10m 12 minutes Girls 0.4m The company requires a closing inventory of 10% of raw material required for the following month's material needed. Thete was no opening stock of taw material. The company plans to have a closing inventory of leather of 6.2m and 13m ef cushioning material as at the 30 September 2 Materials are purchased from a company based in the Cayman Island. This supplier requires that 50% of the purchase total is paid for in cash with the order, and allows one month's credit for the remaining amount (b) In keeping with government requirements, biodegradable cardboard boxes will be used to package the sneakers. Each box will cost $28.50 per box. The company will buy the packaging materials from a Jamaican company for cash each month, (e) To make girls' sneakers, each unit requires 15 minutes of direct labour hours and to make boys' sneakers cach unit requires 12 minutes of direct labour hours. The company pays $340 per hour for cach direct labour hour. Labour costs are paid in the month incurred. Manufacturing Overheads (d) The following manufacturing overheads are budgeted for the quarter. Indirect material Indirect labour Other overhead Depreciation July $10,200 54.800 $3,100 SI.NO August $11.200 54,120 $2,400 S1,800 September SI 2.200 54.280 $2,700 $1,800 In addition to the above overheads the following costs will be incurred: (e) The company has signed a rental agreement for the production facility. The annual rental charge will be $360,000, which will be paid in equal monthly installments. A security deposit amounting to $25,000 must also be paid in July, (Other operating costs including power, insurance, and administration expenses, which must be paid monthly, are expected to be $95.600 for the year, Selling and administrative costs Marketing Companie The company will launch an advertising campaign using social media, television, radio, and newspaper. This will cost $13,600 for three-month period payable in equal instalments from July Stle.commission A 2% commission on projected sales in dollars will be payable for cash in the month incurred. Other selling and administrative expense Other selling and administrative expenses use the following cost function per quarter: y= $24,000 +62x, where x represents budgeted sales in units. Other information (g) The prize money of $500,000 will be introduced at the commencement of the company's operations and should be treated as a cash inflow (capital/investment by owners). Beginning cash balance is nil. (h) The closing inventory as at 30h of September is $28,200 (i.c., raw material closing inventory is $5,154 and finished goods inventory is $23,046). (1) Klean Steppers is seeking $1,000,000 loan from Development Bank of Jamaica to purchase a new equipment costing $216,000 and assist with the operating expenses for its first year of operation. Interest rate on the loan is 12%. The principal and interest will be repaid in 4 installments at the end of each quarter. VI. (16 marks) VIL (13 marks) Direct labour budget Manufacture overhead budget Selling and administrative budget Cash budget VIII. (16 marks) IX (31 marks) X Cost of Goods Sold Budget (quarter only) (5 marks) XI. Budgeted Income Statement (quarter only) (5 marks) XII. Budgeted Balance Sheet (quarter only) (12 marks)