You have learned a tremendous amount about creating the first year's budget for the original option...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You have learned a tremendous amount about creating the first year's budget for the original option of the new TZEdge shoe. Now, you need to create quarterly budgets and a summary for the textured leather option using $74.07 per shoe as the cost of materials and $5.32 per shoe as the cost of labor. Unlike with the original option, only two pricing alternatives are being considered for the textured leather option. Table 1.7 shows the two pricing alternatives, as well as the expected sales volume in each quarter for these alternatives. Overhead is calculated at 29% of the direct labor costs, and the selling expense is assumed to be $5.10 per shoe. Table 1.7: Pricing alternatives for textured leather option 1stQTR 2ndQTR 3rdQTR 4th QTR Alternative: $/Pair #Pairs #Pairs #Pairs #Pairs Low Priced 215 560 710 950 1150 High Priced 255 325 410 535 640 Complete the following: 1. Create a new workbook named 1-5-Texture-Budget-Your-Name.xlsx, and then save the file. 2. Using the finished first quarter budget worksheet for the original option as a model (see Figure 1.24) Figure 1.24: Finished first quarter budget A B C D E F 1 Number of Shoes Per Pair TZEdge First 21 Quarter Budget 2 Overhead % of Labor 25% 3 4 Low Priced Medium Priced High Priced 5 Sales Volume #pairs: 6 Solling Price Per Pair: $ 1,000 200 S 750 225 S 350 250 7 Item 8 Revenue Total $ 200,000 S Costs per Low Priced Medium Priced High Priced Shoo Total 168,750 S Total 87,500 9 10 Cost of Goods Sold: 11 Materials $ 50 15 100,300 75,225 35,105 12 Direct Labor 7.33 14.660 10,995 5,131 13 Overhead 1.83 3.665 2,749 1,283 14 COGS Subtotal 118,625 88,969 41,519 15 16 Selling Expense 5.00 10,000 7.500 3,500 17 18 Projected Earnings S 71,375 5 72.281 5 42.481 19 20 Create the first quarter budget worksheet for the textured leather option, as follows: a. In cells A1:B2, enter the necessary inputs for the number of shoes per pair and the % of labor for overhead. b. In cell C1, enter the title TZEdge 1st Quarter Budget Textured Leather Option in bold and italic. Merge and center this title across cells C1:D1, and wrap the text so this title appears over 2 lines. Apply a gray shaded background to the title cells. c. In rows 4 through 6, enter the first quarter sales volume and price data, with the column headings Low Priced and High Priced in cells C4 and D4, respectively. Use similar formatting as shown in Figure 1.24. You have learned a tremendous amount about creating the first year's budget for the original option of the new TZEdge shoe. Now, you need to create quarterly budgets and a summary for the textured leather option using $74.07 per shoe as the cost of materials and $5.32 per shoe as the cost of labor. Unlike with the original option, only two pricing alternatives are being considered for the textured leather option. Table 1.7 shows the two pricing alternatives, as well as the expected sales volume in each quarter for these alternatives. Overhead is calculated at 29% of the direct labor costs, and the selling expense is assumed to be $5.10 per shoe. Table 1.7: Pricing alternatives for textured leather option 1stQTR 2ndQTR 3rdQTR 4th QTR Alternative: $/Pair #Pairs #Pairs #Pairs #Pairs Low Priced 215 560 710 950 1150 High Priced 255 325 410 535 640 Complete the following: 1. Create a new workbook named 1-5-Texture-Budget-Your-Name.xlsx, and then save the file. 2. Using the finished first quarter budget worksheet for the original option as a model (see Figure 1.24) Figure 1.24: Finished first quarter budget A B C D E F 1 Number of Shoes Per Pair TZEdge First 21 Quarter Budget 2 Overhead % of Labor 25% 3 4 Low Priced Medium Priced High Priced 5 Sales Volume #pairs: 6 Solling Price Per Pair: $ 1,000 200 S 750 225 S 350 250 7 Item 8 Revenue Total $ 200,000 S Costs per Low Priced Medium Priced High Priced Shoo Total 168,750 S Total 87,500 9 10 Cost of Goods Sold: 11 Materials $ 50 15 100,300 75,225 35,105 12 Direct Labor 7.33 14.660 10,995 5,131 13 Overhead 1.83 3.665 2,749 1,283 14 COGS Subtotal 118,625 88,969 41,519 15 16 Selling Expense 5.00 10,000 7.500 3,500 17 18 Projected Earnings S 71,375 5 72.281 5 42.481 19 20 Create the first quarter budget worksheet for the textured leather option, as follows: a. In cells A1:B2, enter the necessary inputs for the number of shoes per pair and the % of labor for overhead. b. In cell C1, enter the title TZEdge 1st Quarter Budget Textured Leather Option in bold and italic. Merge and center this title across cells C1:D1, and wrap the text so this title appears over 2 lines. Apply a gray shaded background to the title cells. c. In rows 4 through 6, enter the first quarter sales volume and price data, with the column headings Low Priced and High Priced in cells C4 and D4, respectively. Use similar formatting as shown in Figure 1.24.
Expert Answer:
Answer rating: 100% (QA)
1 Open a new workbook in your preferred spreadsheet software and save it as 15TextureBudgetYourNamexlsx as instructed 2 Create a worksheet for each quarter 1st 2nd 3rd and 4th quarter and name them ac... View the full answer
Related Book For
Managerial Accounting Decision Making and Performance Management
ISBN: 978-0273764489
4th edition
Authors: Ray Proctor
Posted Date:
Students also viewed these finance questions
-
Find in a newspaper or similar news source, (such as the New York Times or the Wall Street Journal) an article related to biology. The article must be within one year. Critically read the article....
-
3 kg of gas in a piston-cylinder assembly undergo a process during which the relationship between pressure and specific volume is pv^1.25 = constant. The process begins with p_1 = 300 kPa and V_1 =...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
Classify each of the following items as a public good, a private good, a mixed good, or a common resource. Georges Banks cod stock A courtside seat at the U.S. Open (tennis) A well-stocked buffet...
-
Why must an application gateway work in conjunction with a router filter to be effective?
-
Metge Corporation's worksheet for calculating taxable income for 2017 follows: ($ in thousands)________________________________2017 Pre-tax income..................................................
-
The excerpt that follows is from a recent article on the financial reporting of Amazon.com, the famous Internet seller. From the beginning, Bezos [Amazon.coms Chairman and CEO] told shareholders that...
-
1. Identify the entities and their relationships. Then create an ERD for the reservations system. 2. Create 3NF table designs for the system. 3. For each of the entities identified, design tables and...
-
Lew started a business writing a popular syndicated Japanese gardening column the current year (2015) will report a profit for his first year. His results of operations are as follows ; (Use schedule...
-
Caterham PLC distributes sports equipment for sale to a number of High Street chains, importing branded goods from China and India. The company has several distribution and delivery hubs throughout...
-
Need sql query for creating a table Paste File M9 ~ 34567 2 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 Home A 1 notification_date Ready Cut Copy Format...
-
What mechanisms and feedback loops are necessary for organizations to capture lessons learned from past decisions and apply them to future decision-making contexts ?
-
What are some downsides to quick service? Describe situations under which speed of service is not important to a customer. Are there, however, aspects within slow-serve situations that still require...
-
What are the key drivers that are forcing healthcare organizations to greater levels of HIT adoption? Provide at least one academic resource to support your opinion in your initial post.
-
What are the standard project phases?
-
what are some of opportunity risk a fast food restaurant would faces? what would be the gain and the loss of this risk? what are some of the hazard risk, control risk and compliance risk harveys also...
-
15 ok nt The Fashion Shoe Company operates a chain of women's shoe shops that carry many styles of shoes that are all sold at the same price. Sales personnel in the shops are paid a sales commission...
-
On January 2, 20X3, Sheldon Bass, a professional engineer, moved from Calgary to Edmonton to commence employment with Acco Ltd., a large public corporation. Because of his new employment contract,...
-
Stobo plc is a well-known national chain of high-street chemists. Its traditional markets of pharmaceuticals and beauty products are becoming increasingly competitive due to the aggressive entry of...
-
Gorgon Group plc is a manufacturer with a divisional structure. The Odeen division makes a single product which it sells outside the Gorgon Group as well as to the Trey division. Odeens product has a...
-
The current annual budget for King & Co., makers of baseball caps, is summarized as follows: ...............................................................................................000 Sales...
-
On December 31, 20x7, the stockholders equity section of Tsang Companys balance sheet appeared as follows: The following are selected transactions involving stockholders equity in 20x8: On January 4,...
-
Recording Purchase and Sales Transactions} Raymond Company and Geeslin Company both use a perpetual inventory system. The following transactions occurred during the month of January: Jan. 1 Raymond...
-
Inventory Costing Methods} Refer to the information for Tyler Company above and assume the company uses a perpetual inventory system. \section*{Required:} Calculate ending inventory and cost of goods...
Study smarter with the SolutionInn App