Your company is competing for business in the toy robot industry Prepare a sales, production, direct...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Your company is competing for business in the toy robot industry Prepare a sales, production, direct materials, and direct labor budget based on the following assumptions Assumptions Q1 Q2 Q4 1. Sales Projections (Units) 10,000 15,000 17,000 Q4 25,000 7. Material Needs 1 Lb. per unit of plastic 8. Material Costs $2 per pound of plastic 2. Sales Price per Unit $25.00 9. Material Desired Ending Inventory 10% of next months Units lbs. 10. Material Beginning Inventory The same as the previous quarters ending inventory. lbs. 5. Desired Ending Inventory 10% of next quarters sales 6. Beginning Inventory The same as the prior quarters ending inventory. 11. Labor Costs $20 per hour 12. Time to produce one mouse 0.25 hour NOTE: To protect the integrity of the numbers within this Workbook, each spreadsheet has been protected so that you can only access the yellow cells. If you wish to utilize the ability to create formulas within Excel... Go to the File Tab, Select Info, Below "Protect Workbook", Select "Unprotect" after each spreadsheet name. Units Sales Price Total Sales Sales Budget Expected Sales in Units Q1 Q2 Q3 Q4 $0 $0 $0 $0 TechGadgets Co. sells their Robot Kits for $25 each. In 20XX the company expects to sell 10,000 units in Quarter 1; 15,000 in Quarter 2; 17,000 in Quarter 3; and 25,000 in Quarter 4; with no change in the Selling Price. Production Budget Expected number of goods to be produced to meet the sales projection What you need: Sales Forecast data from the Sales Budget Ending Inventory - inventory left over from the previous time period Beginning Inventory - what is left over from the previous reporting period TechGadgets Co. projects the following unit sales in 2023 the company expects to sell 10,000 units in Quarter 1, 15,000 in Quarter 2, 17,000 in Quarter 3 and 25,000 in Quarter 4. TechGadgets Co. desires an ending inventory of 10% of next quarters planned units and its beginning inventory is equal to the previous quarters ending inventory. Because this is a new product, we will have a beginning inventory of zero in quarter 1, and Quarter 4's desired ending inventory will be provided. Q1 Q2 Q3 Q4 Planned Sales (in units) Desired Ending Inventory (in units) Needed Inventory (in units) Less Beginning Inventory Units to be Produced 0 2,000 2,000 2,000 To meet the sales projection, how many Robot Kits do you have to produce? Direct Material Budget Expected material that will be needed for production What you need: Units to be produced - taken from Production Budget Materials needed to produce each unit (an assumption) Desired ending inventory of materials (an assumption) Beginning inventory of materials (an assumption) Unit price per lb. (an assumption) TechGadgets Co. created a Production Budget to project the Production Needs in Units for each quarter to make their Robot Kits. Use the production needs in units found in the Production Budget to complete the Direct Materials Budget. Each Unit requires 1 pounds of plastic which cost $2.00 per 1 pound. TechGadgets Co. desires a material ending inventory of 10% of next quarters production needs and its material beginning inventory is equal to the previous quarters ending inventory. Because this is a new product, we will have a beginning inventory of zero in quarter 1, and Quarter 4's desired ending inventory will be provided. Q1 Q2 Q3 Q4 Planned Production Needs (in units) Materials needed to produce a unit (assumption) Production Needs (lbs) Desired Ending Inventory of materials (lbs) Total Needs (lbs) 2,000 2,000 Less: Beginning Inventory of materials (lbs) Needed Materials (lbs) 2,000 Cost of materials to produce one unit Cost of Materials to Produce Required Units based on Sales Projection $ $ - $ - $ What will it cost you in Q1 for material? Direct Labor Budget Expected costs to produce required products What you need: Units to be produced - taken from Production Budget Direct labor hours required to produce one unit (an assumption) Cost of labor per hour (an assumption) Q1 Q2 Q3 Q4 Required Units to be Produced (taken from Production Budget) Direct Labor Hours required to produce one unit Production Needs Cost of Labor per hour Total Cost of Labor to Produce Required Units to Meet Sales Budget What is it going to cost you in labor to produce the number of Robot Kits required to meet revenue projections? TechGadgets Co. created a Production Budget to project the Production Needs in Units for each quarter to make their Robot Kits. Use the production needs in units found in the Production Budget to complete the Direct Labor Budget. In order to produce their Robot Kits, TechGadgets Co. will require Labor Costs of $20 per hour and needs 0.25 hours to produce one Unit. Projected Sales (Revenue) Cost of Goods Sold - Material Costs - Labor Costs Gross Profit Calculation Projected Revenue - Projected Cost of Goods Sold Gross Profit Percentage -(Revenue - COGS)/ Revenue *100 Is it Worth It? $625,000 TechGadgets Co. created a Master Budget to project the needs in units and costs associated with the manufacturing of their Robot Kits. Tech Gadgets Co. wants to look at whether it will be a favorable or unfavorable year. To evaluate this, TechGadgets Co. will need to utilize the Master Budget to create an Income Statement. (For the purpose of this assignment we will only create the top half of the Incomes Statement that represents to Sales, Cost of Goods Sold, and the Gross Profit.) Q1 $250,000 Q2 Q3 Q4 $375,000 $425,000 $250,000 $375,000 $425,000 $625,000 100% 100% 100% 100% Your company is competing for business in the toy robot industry Prepare a sales, production, direct materials, and direct labor budget based on the following assumptions Assumptions Q1 Q2 Q4 1. Sales Projections (Units) 10,000 15,000 17,000 Q4 25,000 7. Material Needs 1 Lb. per unit of plastic 8. Material Costs $2 per pound of plastic 2. Sales Price per Unit $25.00 9. Material Desired Ending Inventory 10% of next months Units lbs. 10. Material Beginning Inventory The same as the previous quarters ending inventory. lbs. 5. Desired Ending Inventory 10% of next quarters sales 6. Beginning Inventory The same as the prior quarters ending inventory. 11. Labor Costs $20 per hour 12. Time to produce one mouse 0.25 hour NOTE: To protect the integrity of the numbers within this Workbook, each spreadsheet has been protected so that you can only access the yellow cells. If you wish to utilize the ability to create formulas within Excel... Go to the File Tab, Select Info, Below "Protect Workbook", Select "Unprotect" after each spreadsheet name. Units Sales Price Total Sales Sales Budget Expected Sales in Units Q1 Q2 Q3 Q4 $0 $0 $0 $0 TechGadgets Co. sells their Robot Kits for $25 each. In 20XX the company expects to sell 10,000 units in Quarter 1; 15,000 in Quarter 2; 17,000 in Quarter 3; and 25,000 in Quarter 4; with no change in the Selling Price. Production Budget Expected number of goods to be produced to meet the sales projection What you need: Sales Forecast data from the Sales Budget Ending Inventory - inventory left over from the previous time period Beginning Inventory - what is left over from the previous reporting period TechGadgets Co. projects the following unit sales in 2023 the company expects to sell 10,000 units in Quarter 1, 15,000 in Quarter 2, 17,000 in Quarter 3 and 25,000 in Quarter 4. TechGadgets Co. desires an ending inventory of 10% of next quarters planned units and its beginning inventory is equal to the previous quarters ending inventory. Because this is a new product, we will have a beginning inventory of zero in quarter 1, and Quarter 4's desired ending inventory will be provided. Q1 Q2 Q3 Q4 Planned Sales (in units) Desired Ending Inventory (in units) Needed Inventory (in units) Less Beginning Inventory Units to be Produced 0 2,000 2,000 2,000 To meet the sales projection, how many Robot Kits do you have to produce? Direct Material Budget Expected material that will be needed for production What you need: Units to be produced - taken from Production Budget Materials needed to produce each unit (an assumption) Desired ending inventory of materials (an assumption) Beginning inventory of materials (an assumption) Unit price per lb. (an assumption) TechGadgets Co. created a Production Budget to project the Production Needs in Units for each quarter to make their Robot Kits. Use the production needs in units found in the Production Budget to complete the Direct Materials Budget. Each Unit requires 1 pounds of plastic which cost $2.00 per 1 pound. TechGadgets Co. desires a material ending inventory of 10% of next quarters production needs and its material beginning inventory is equal to the previous quarters ending inventory. Because this is a new product, we will have a beginning inventory of zero in quarter 1, and Quarter 4's desired ending inventory will be provided. Q1 Q2 Q3 Q4 Planned Production Needs (in units) Materials needed to produce a unit (assumption) Production Needs (lbs) Desired Ending Inventory of materials (lbs) Total Needs (lbs) 2,000 2,000 Less: Beginning Inventory of materials (lbs) Needed Materials (lbs) 2,000 Cost of materials to produce one unit Cost of Materials to Produce Required Units based on Sales Projection $ $ - $ - $ What will it cost you in Q1 for material? Direct Labor Budget Expected costs to produce required products What you need: Units to be produced - taken from Production Budget Direct labor hours required to produce one unit (an assumption) Cost of labor per hour (an assumption) Q1 Q2 Q3 Q4 Required Units to be Produced (taken from Production Budget) Direct Labor Hours required to produce one unit Production Needs Cost of Labor per hour Total Cost of Labor to Produce Required Units to Meet Sales Budget What is it going to cost you in labor to produce the number of Robot Kits required to meet revenue projections? TechGadgets Co. created a Production Budget to project the Production Needs in Units for each quarter to make their Robot Kits. Use the production needs in units found in the Production Budget to complete the Direct Labor Budget. In order to produce their Robot Kits, TechGadgets Co. will require Labor Costs of $20 per hour and needs 0.25 hours to produce one Unit. Projected Sales (Revenue) Cost of Goods Sold - Material Costs - Labor Costs Gross Profit Calculation Projected Revenue - Projected Cost of Goods Sold Gross Profit Percentage -(Revenue - COGS)/ Revenue *100 Is it Worth It? $625,000 TechGadgets Co. created a Master Budget to project the needs in units and costs associated with the manufacturing of their Robot Kits. Tech Gadgets Co. wants to look at whether it will be a favorable or unfavorable year. To evaluate this, TechGadgets Co. will need to utilize the Master Budget to create an Income Statement. (For the purpose of this assignment we will only create the top half of the Incomes Statement that represents to Sales, Cost of Goods Sold, and the Gross Profit.) Q1 $250,000 Q2 Q3 Q4 $375,000 $425,000 $250,000 $375,000 $425,000 $625,000 100% 100% 100% 100%
Expert Answer:
Answer rating: 100% (QA)
The question seems to be related to preparing a series of budgets for a company in the toy robot industry To answer this question we will need to compile a Sales Budget a Production Budget a Direct Ma... View the full answer
Related Book For
Managerial Accounting Decision Making and Motivating Performance
ISBN: 978-0137024872
1st edition
Authors: Srikant M. Datar, Madhav V. Rajan
Posted Date:
Students also viewed these accounting questions
-
Complete the following table of test statistics (i.e., t-stats) on the calculated betas. CC 5-year 2-year regression regression regression 2015-2019 2015-2016 2018-2019 2-year KM GM 6.6 6.1 3.5 Ford...
-
A 4.0kg-ceiling fan is placed 2.5m above the floor. What is the gravitational potential energy of the earth-ceiling fan system relative to the floor?
-
Which 4 of these items or transactions do you need to create to record a bounced check and any related fees? A credit memo to post the fact that the first invoice is no longer outstanding A service...
-
Suppose you come from a part of the world that is blessed with abundant water. Demand never comes close to the available amount. Should you be careful about the amount you use or should you simply...
-
The company recorded the following summary journal entries during July. a. Cash ............................................. 30,000 Sales .............................................................
-
In Problems 1 through 12 first solve the equation f (x) = 0 to find the critical points of the given autonomous differential equation dx/dt = f (x) Then analyze the sign of f (x) to determine whether...
-
The following information has been extracted from the books of account of Rufford plc for the year to 31 March 2006: Additional information: : 1. Administrative expenses include the following items:...
-
Koontz Company manufactures a number of products. The standards relating to one of these products are shown below, along with actual cost data for May. The production superintendent was pleased when...
-
. LEARNING ACTIVITIES 3 below Instructions. Read carefully and analyze each transaction. Prepare the requirements being asked for On August 1, 2021, Samuel Barbo, a recent medical board passer who...
-
The paralegal is assigned the task of preparing an office legal memorandum. The memorandum is due in 10 days, and there is a 5-page limit. The facts and law are as follows: Facts: Mary was Tom's...
-
La ventaja competitiva en un mercado global se adquiere mediante: A) Reducir costos para mantener cautivos a clientes globales B) enfrentar mercados desconocidos con culturas distintas C) Recurrir a...
-
How much tax will Hanna pay on her qualified dividends and capital gains?
-
b) A simple crypto algorithm is used to protect data from unauthorised users. The plain text (the unprotected data) of 8-bit size is fed to the avr32 microcontroller that runs the algorithm. The...
-
A hunger for knowledge is China's real secret weapon Question 1 How can learning increase the competitive advantage of Chinese firms? Question 2 What issues do firms need to consider when adapting to...
-
After formally retiring at the age of 68, a financial analyst continues to use the term "retired financial analyst" when being introduced to new people. This individual provides an example of which...
-
Feather Friends, Incorporated, distributes a high-quality wooden birdhouse that sells for $120 per unit. Variable expenses are $60.00 per unit, and fixed expenses total $200,000 per year. Its...
-
Denise, an Australian resident, is a self-funded retiree from Sydney, who is planning, this year, on moving to Hobart and purchasing a home. This will be the first home she had ever purchased. She...
-
Use the formula to determine the value of the indicated variable for the values given. Use a calculator when one is needed. When necessary, use the key on your calculator and round answers to the...
-
Required For the data in Exercise 5- 14, summarize total costs to account for, calculate cost per equivalent unit for direct materials and conversion costs, and assign total costs to units completed...
-
Refer to Exercise 14- 21. Required 1. Calculate the amount and cost of unused software- implementation support capacity at the beginning of 2012, based on the number of jobs actually done in 2012. 2....
-
Harrison, Inc., manufactures karaoke machines for several well- known companies. The machines differ significantly in their complexity and their manufacturing batch sizes. The following costs were...
-
Turbo Corporation had net income of \(\$ 30,000\) and other comprehensive income of \(\$ 0\) prior to the following two adjustments: Turbo Corporation discovered it has an unrealized holding loss of...
-
Lance Co. purchased 100 shares of Mallard common stock at \$20 per share on March 15, 2020. Mallard declared and paid a dividend of \(\$ 1.50\) per share in 2020. The market price on December 31,...
-
An investor purchased 100 shares of Mallard common stock at \(\$ 20\) per share on March 15, 2020. On December 31, 2020, the stock was quoted at \(\$ 19\) per share and declared and paid a dividend...
Study smarter with the SolutionInn App