A group of students at the University of Technology, Jamaica recently won an award in the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A group of students at the University of Technology, Jamaica recently won an award in the annual UTech, Ja Business Model Competition for their invention, a white dirt-proof sneaker 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 sneakers 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: Selling price Type Girls Boys $2500 $2900 July 250 195 Girls Boys August 290 230 Months September 320 280 It is expected that all sales will be on credit to department stores in Jamaica. It is estimated that 30% of customers will pay within one month while the remaining customers will pay the month following sale. Leather $370 per meter 0.6m 0.4m 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. October 190 160 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 each pair of sneakers are as follows: Type of sneakers Cushion $220 per meter 0.15m 0.10m Labour $340 per hour 15 minutes 12 minutes The company requires a closing inventory of 10% of raw material required for the following month's material needed. There was no opening stock of raw material. The company plans to have a closing inventory of leather of 6.2m and 13m of cushioning material as at the 30th September. 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. (c) To make girls' sneakers, each unit requires 15 minutes of direct labour hours and to make boys' sneakers each unit requires 12 minutes of direct labour hours. The company pays $340 per hour for each 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 $4,800 $3,100 $1,800 Selling and administrative costs August $11,200 $4,120 $2,400 $1,800 September $12,200 $4,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 instalments. A security deposit amounting to $25,000 must also be paid in July. (f) Other operating costs including power, insurance, and administration expenses, which must be paid monthly, are expected to be $93,600 for the year. Marketing Campaign The company will launch an advertising campaign using social media, television, radio, and newspaper. This will cost $33,600 for three-month period payable in equal instalments from July. Sales commission A 2% commission on projected sales in dollars will be payable for cash the month incurred. 3/4 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 30th of September is $28,200 (i.e., raw material closing inventory is $5,154 and finished goods inventory is $23,046). (i) 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. Requirements: Prepare Klean Steppers master budget for month and in total for the quarter by completing the following schedules and statements: Sales budget Schedule of cash collected from customers Production budget Direct-material budget I. II. III. IV. V. VI. VII VIII. IX. X. XI. Schedule of cash disbursement to suppliers for direct material Direct labour budget Manufacture overhead budget Selling and administrative budget Cash budget Cost of Goods Sold Budget (quarter only) Budgeted Income Statement (quarter only) XII. Budgeted Balance Sheet (quarter only) (12 marks) (8 marks) (28 marks) (42 marks) (12 marks) (16 marks) (13 marks) (16 marks) (31 marks) (5 marks) (5 marks) (12 marks) [TOTAL 200 MARKS] A group of students at the University of Technology, Jamaica recently won an award in the annual UTech, Ja Business Model Competition for their invention, a white dirt-proof sneaker 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 sneakers 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: Selling price Type Girls Boys $2500 $2900 July 250 195 Girls Boys August 290 230 Months September 320 280 It is expected that all sales will be on credit to department stores in Jamaica. It is estimated that 30% of customers will pay within one month while the remaining customers will pay the month following sale. Leather $370 per meter 0.6m 0.4m 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. October 190 160 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 each pair of sneakers are as follows: Type of sneakers Cushion $220 per meter 0.15m 0.10m Labour $340 per hour 15 minutes 12 minutes The company requires a closing inventory of 10% of raw material required for the following month's material needed. There was no opening stock of raw material. The company plans to have a closing inventory of leather of 6.2m and 13m of cushioning material as at the 30th September. 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. (c) To make girls' sneakers, each unit requires 15 minutes of direct labour hours and to make boys' sneakers each unit requires 12 minutes of direct labour hours. The company pays $340 per hour for each 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 $4,800 $3,100 $1,800 Selling and administrative costs August $11,200 $4,120 $2,400 $1,800 September $12,200 $4,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 instalments. A security deposit amounting to $25,000 must also be paid in July. (f) Other operating costs including power, insurance, and administration expenses, which must be paid monthly, are expected to be $93,600 for the year. Marketing Campaign The company will launch an advertising campaign using social media, television, radio, and newspaper. This will cost $33,600 for three-month period payable in equal instalments from July. Sales commission A 2% commission on projected sales in dollars will be payable for cash the month incurred. 3/4 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 30th of September is $28,200 (i.e., raw material closing inventory is $5,154 and finished goods inventory is $23,046). (i) 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. Requirements: Prepare Klean Steppers master budget for month and in total for the quarter by completing the following schedules and statements: Sales budget Schedule of cash collected from customers Production budget Direct-material budget I. II. III. IV. V. VI. VII VIII. IX. X. XI. Schedule of cash disbursement to suppliers for direct material Direct labour budget Manufacture overhead budget Selling and administrative budget Cash budget Cost of Goods Sold Budget (quarter only) Budgeted Income Statement (quarter only) XII. Budgeted Balance Sheet (quarter only) (12 marks) (8 marks) (28 marks) (42 marks) (12 marks) (16 marks) (13 marks) (16 marks) (31 marks) (5 marks) (5 marks) (12 marks) [TOTAL 200 MARKS]
Expert Answer:
Answer rating: 100% (QA)
Answer I In computing the sales budget we are going to use the work back format wherein we will start with the Projected Sales in units for the month multiplied by the sales price Using the data from ... View the full answer
Related Book For
Applied Statistics for Public and Nonprofit Administration
ISBN: 978-1285737232
9th edition
Authors: Kenneth J. Meier, Jeffrey L. Brudney, John Bohte
Posted Date:
Students also viewed these accounting questions
-
A professor thinks that the MPA students at the University of Arizona (UA) are brighter than those at the University of Georgia (UGA). To examine this hypothesis, he gives the same midterm to UA...
-
A group of students on spring break manages to reach a deserted island in their wrecked sailboat. They splash ashore with fuel, a European gasoline-powered 240-V generator, a box of North American...
-
A group of students had their IQs measured at the start, middle, and end of a school year. The three means, respectively, were 125.5, 127.5, and 130.5. A one-way, repeated measures ANOVA was used to...
-
Mrs. Ridhima had a factory situated in Delhi which he transferred to Uttar Pradesh and closed all operations in Delhi. Whether it will constitute a slump sale and whether it is liable to tax under...
-
A start-up company is building a database of customers and sales information. For each customer, it records name, ID number, region of the country (1 = East, 2 = South, 3 = Midwest, 4 = West), date...
-
The manufacturing costs of Ackerman Industries for the first three months of the year follow: Total Costs Units Produced January.$1,900,00020,000 units February.2,250,000.27,000...
-
Show that the stochastic process \[e^{\int_{0}^{t} c(s) d B_{s}-\frac{1}{2} \int_{0}^{t} c^{2}(s) d s}\] is a martingale for any deterministic function \(c(t)\). Does the result change if \(c(t,...
-
The following data were taken from the general ledgers and other data of Alpha Manufacturing, Inc., and Bravo Merchandising Co. on April 30 of the current year: Merchandise inventory, April 1 . . . ....
-
Beginning Investment in the business: The owner of the company has invested $18,000 cash into the business. This increases the assets of the business from its zero balance. Owner's equity also...
-
Toms, Inc., produces various Mexican food products and sells them to Western Foods, a chain of grocery stores located in Texas and New Mexico. Toms, Inc., makes two salsa products: Western Foods...
-
Which one of these statements related to growing annuities and perpetuities is correct? A. The cash flow used in the growing annuity formula is the initial cash flow at time zero. B. Growth rates...
-
Bats use ultrasound to measure how far they are from objects around them. As we have done in class, we suppose that the value of the wavelength gives an estimate of how small on object can be...
-
In a Calorimetry experiment, a 20.0g metal ball is heated to 150 Cand dropped into a perfectly insulating container with 200 g of water initially at 20.0 C. After stirring the water for a few...
-
Viasat's Return-to-Earth Ground Station service in Alice Springs, AU, is a 7.34m antenna with an advertised G/T of 32.0 dB/K at X-band (8.4 GHz) and 34.5 dB/K at Ka-band (26 GHz). a) At 60%...
-
Resonance is obtained at a frequency of 27kHz for a RLC series circuit with the capacitance value, 0.03F. Determine the value of the inductance in SI units. Enter only the numeral of your answer.
-
Assume you have a glass rod surrounded by air, as shown in Figure angle. Find the critical incident glass rod: n = 1.5 air: n = 1.0 81810
-
Question 1 The following table shows the relationship between the number of workers and output on a given hour. Each worker costs $45 per hour, and the firm pays $200 for equipment. Table 1 Workers...
-
Draw and label the E and Z isomers for each of the following compounds: 1. CH3CH2CH==CHCH3 2. 3. 4. CH,CH2C CHCH2CH Cl CH3CH2CH2CH2 CH CH2CCCH2CI CHCH3 CH3 HOCH CH CCC CH O-CH C(CH
-
Six months ago, a bureau employed seven women out of a total workforce of 57. A federal commission cited the bureau for discrimination in hiring and informed the bureau that great changes would have...
-
Springdale University and the Springdale United Way jointly administer a student volunteerism program. Last year, students in the program volunteered an average of 7.3 hours of community service per...
-
Ima Fastrack is a data analyst at the Oakmont Civil Service Commission. When she was first hired 3 months ago, she was satisfied with her salary of $ 24,832. In the time since she was hired, Ima has...
-
As problems 5.18 and 5.19 reflect, the air temperature in the test section of conventional hypersonic wind tunnels is low. In reality, air liquefies at a temperature of about \(50 \mathrm{~K}\)...
-
The reservoir temperature calculated in problem 5.20 is beyond the capabilities of heaters in the reservoir of continuous-flow wind tunnels using air. This is why you do not see a Mach 20...
-
Write the \(y\) component of Eq. (6.7), and use it to derive Eq. (6.12). Equation 6.12: \(\frac{\partial(ho v)}{\partial t}+abla \cdot(ho v \mathbf{V})=-\frac{\partial p}{\partial y}+ho f_y\) V pfd7...
Study smarter with the SolutionInn App