Calculation Procedure for Construction (Fixed Cost) The program that you create will perform a complete Breakeven...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Calculation Procedure for Construction (Fixed Cost) The program that you create will perform a complete Breakeven Analysis for a single construction option. Your team then should be able to perform several complete Breakeven Analyses in order to provide the final financial benefits of a single construction option. To begin, your team must calculate the total cost of construction for three different construction materials. The total construction cost will be the "fixed cost" of your analysis. To begin, there will be 3 construction materials to choose from and all the information MUST be contained within one 3 x 7 cell array. The cell array will be organized as below (do NOT include the titles highlighted in gray): Material Concrete Wood Adobe Thickness of wall Material cost [in] [S/ft'] 16 23 18 30 53 42 Miscellaneous Construction Materials [S] 96,000 115,000 68,000 Labor Cost [S/(person week) 900 800 600 Number of Laborers (people) 5 12 6 Number of weeks of construction 5 11 5 . The program should use a menu listing three material options: Concrete, Wood, or Adobe, pulled from the cell array. You may NOT hardcode or use an "if statement/switch statement" to retrieve these names. This menu should automatically change should the cell array be altered as to the number and types of materials. . The program should set the total surface area of the wall to be 3000 square feet. • The program should then calculate the total cost of construction considering all costs above, in appropriate units. You should use this total as your fixed cost. Note: In all your calculations, your numbers should be able to automatically adjust should more materials be added to the cell array. No credit will be given to hardcoded values or the use of "if statements/switch statements" or the use of "loops." Breakeven Analysis (Variable Costs and Revenue Details) The program that you create will then perform the rest of the Breakeven Analysis for the single construction option specified by the user. Each option has a specific amount of variable costs that are listed later in this document (under the "Options to Consider" section). These variable costs should be entered as user-inputs rather than hardcoded or entered into the cell array above. They must be "free form" input by the user (should the costs change in the near future). The inputs are listed below: The program should now ask the user to enter the following information relating to the operational (variable) costs, operational schedule, and number of years for the analysis: Energy cost [$/week] Labor cost [$/week] Maintenance cost [$/week] Landfill cost [$/week] . Number of weeks per year the zoo will operate o Number of years the analysis should include (this is INDEPENDENT of the construction time. Your analysis at time zero should be OPENING DAY) . The program should finally ask the user to enter the zoo's anticipated public interest and donations, which will be used to calculate revenue: Price of admission per person [S/person] Number of people per week that will visit the zoo . Expected donations per week [$/week] Breakeven Analysis (Process) The program should conduct a breakeven analysis using these steps: . Determine the total fixed costs to construct the enclosure considering material costs, miscellaneous costs, and labor costs • Determine the total variable cost of operating the enclosure per week. . Determine the total cost to operate the selected construction option for the number of years requested by the user (the time does NOT include construction time). The total cost vector should be calculated for the number of years requested, where each column is a year. . Determine the total revenue for the number of years requested by the user. The total revenue vector should be calculated for the number of years requested, where each column is a year. The calculation should include the donations • Determine the total profit for the number of years requested by the user. The total profit vector should be calculated for the number of years requested, where each column is a year. The program should now determine the breakeven point in months. This should be accomplished by creating a mathematical formula to express the breakeven point as a function of cost. The program should also, at the request of the zoo, determine how much of a one-time donation it would take to "breakeven" at the end of 7 months. You may assume that none of the given options will break even in less than 6 months. Summary of Results In the program, first, summarize the results in a manner similar to Summary of Results In the program, first, summarize the results in a manner similar to the following in the Command Window: Material: Concrete Operating ## weeks per year will generate per year: Revenue: Cost: 令#### $#### The breakeven time is # #.## months The total profit after ## years is $#.###e+##. The operating weeks, revenue, cost, and years should be displayed with no decimal places, the breakeven time should be displayed with two decimals, and the total profit should be displayed in exponential notation with three decimal places. The material name should change according to the user's material choice. In addition, the lines should be shown using tabs to indent from the left margin as shown. Second, a statement, such as bolded below, should summarize your program's findings for the amount of the one-time donation necessary to breakeven in seven months. It will take a one-time donation of $#####.## to breakeven in seven months. Finally, your program should create two figures: . The program should generate a proper plot with the number of years on the abscissa, and the revenue and total cost on the ordinate for the construction option. This figure should also include a large point on the line to indicate the breakeven point computed by the code. . The program should generate an additional proper plot (in a separate figure window) to display the profit of the construction choice with respect to time in years. This figure should also include a large point on the line to indicate the breakeven point computed by the code. Options to Evaluate The zoo has asked that you consider running your analysis for at Options to Evaluate The zoo has asked that you consider running your analysis for at least 5 years. For each construction cost, the user should be able to choose the material from a menu then manually enter all other inputs. First, the concrete has several advantages and some disadvantages. Concrete is the least expensive material with a moderate operating cost. It saves on energy costs due to its ability to insulate. However, it is also the least aesthetically appealing material and does not keep with the theme of the zoo. Because of this, fewer people will visit the enclosure, the price per ticket must be decreased, and the amount of donations will decrease. The particular details are as follows: .Name: Concrete Energy Cost: $5,000/week Operational Labor Cost: $4,000/week • Maintenance Cost: $3,000/week .Landfill Cost: $3,000/week Number of weeks per year: 50 • Number of years for analysis: 5 Admission Price: $2/person •Number of People: 9,000/week • Donations per week: $400/week Second, the wood has several advantages and some disadvantages as well. Wood keeps well with the theme of the zoo and is very attractive. Therefore, more people will want to see the enclosure at an even higher price and will be more prone to donate even more to help with the research. However, it is also the most expensive material and has a higher maintenance cost and energy cost. The particular details are as follows: • Name: Wood • Energy Cost: $10,000/week Onerational Labor Cost: $6.000/week to help with the research. However, it is also the most expensive material and has a higher maintenance cost and energy cost. The particular details are as follows: • Name: Wood - Energy Cost: $10,000/week Operational Labor Cost: $6,000/week - Maintenance Cost: $20,000/week Landfill Cost: $3,000/week Number of weeks per year: 50 •Number of years for analysis: 5 Admission Price: $3/person Number of People: 17,500/week • Donations per week: $1,000/week Finally, the adobe strikes a compromise between the other two materials. Adobe can be used to imitate wood and therefore attract more people at a higher price than concrete (though not as much as wood). It also is cheaper in material and maintenance cost wood (though not as good as concrete). The particular details are as follows: .Name: Adobe • Energy Cost: $6,000/week • Operational Labor Cost: $4,000/week • Maintenance Cost: $5,000/week • Landfill Cost: $3,000/week -Number of weeks per year: 50 Number of years for analysis: 5 • Admission Price: $2/person Number of People: 13,000/week • Donations per week: $650/week Calculation Procedure for Construction (Fixed Cost) The program that you create will perform a complete Breakeven Analysis for a single construction option. Your team then should be able to perform several complete Breakeven Analyses in order to provide the final financial benefits of a single construction option. To begin, your team must calculate the total cost of construction for three different construction materials. The total construction cost will be the "fixed cost" of your analysis. To begin, there will be 3 construction materials to choose from and all the information MUST be contained within one 3 x 7 cell array. The cell array will be organized as below (do NOT include the titles highlighted in gray): Material Concrete Wood Adobe Thickness of wall Material cost [in] [S/ft'] 16 23 18 30 53 42 Miscellaneous Construction Materials [S] 96,000 115,000 68,000 Labor Cost [S/(person week) 900 800 600 Number of Laborers (people) 5 12 6 Number of weeks of construction 5 11 5 . The program should use a menu listing three material options: Concrete, Wood, or Adobe, pulled from the cell array. You may NOT hardcode or use an "if statement/switch statement" to retrieve these names. This menu should automatically change should the cell array be altered as to the number and types of materials. . The program should set the total surface area of the wall to be 3000 square feet. • The program should then calculate the total cost of construction considering all costs above, in appropriate units. You should use this total as your fixed cost. Note: In all your calculations, your numbers should be able to automatically adjust should more materials be added to the cell array. No credit will be given to hardcoded values or the use of "if statements/switch statements" or the use of "loops." Breakeven Analysis (Variable Costs and Revenue Details) The program that you create will then perform the rest of the Breakeven Analysis for the single construction option specified by the user. Each option has a specific amount of variable costs that are listed later in this document (under the "Options to Consider" section). These variable costs should be entered as user-inputs rather than hardcoded or entered into the cell array above. They must be "free form" input by the user (should the costs change in the near future). The inputs are listed below: The program should now ask the user to enter the following information relating to the operational (variable) costs, operational schedule, and number of years for the analysis: Energy cost [$/week] Labor cost [$/week] Maintenance cost [$/week] Landfill cost [$/week] . Number of weeks per year the zoo will operate o Number of years the analysis should include (this is INDEPENDENT of the construction time. Your analysis at time zero should be OPENING DAY) . The program should finally ask the user to enter the zoo's anticipated public interest and donations, which will be used to calculate revenue: Price of admission per person [S/person] Number of people per week that will visit the zoo . Expected donations per week [$/week] Breakeven Analysis (Process) The program should conduct a breakeven analysis using these steps: . Determine the total fixed costs to construct the enclosure considering material costs, miscellaneous costs, and labor costs • Determine the total variable cost of operating the enclosure per week. . Determine the total cost to operate the selected construction option for the number of years requested by the user (the time does NOT include construction time). The total cost vector should be calculated for the number of years requested, where each column is a year. . Determine the total revenue for the number of years requested by the user. The total revenue vector should be calculated for the number of years requested, where each column is a year. The calculation should include the donations • Determine the total profit for the number of years requested by the user. The total profit vector should be calculated for the number of years requested, where each column is a year. The program should now determine the breakeven point in months. This should be accomplished by creating a mathematical formula to express the breakeven point as a function of cost. The program should also, at the request of the zoo, determine how much of a one-time donation it would take to "breakeven" at the end of 7 months. You may assume that none of the given options will break even in less than 6 months. Summary of Results In the program, first, summarize the results in a manner similar to Summary of Results In the program, first, summarize the results in a manner similar to the following in the Command Window: Material: Concrete Operating ## weeks per year will generate per year: Revenue: Cost: 令#### $#### The breakeven time is # #.## months The total profit after ## years is $#.###e+##. The operating weeks, revenue, cost, and years should be displayed with no decimal places, the breakeven time should be displayed with two decimals, and the total profit should be displayed in exponential notation with three decimal places. The material name should change according to the user's material choice. In addition, the lines should be shown using tabs to indent from the left margin as shown. Second, a statement, such as bolded below, should summarize your program's findings for the amount of the one-time donation necessary to breakeven in seven months. It will take a one-time donation of $#####.## to breakeven in seven months. Finally, your program should create two figures: . The program should generate a proper plot with the number of years on the abscissa, and the revenue and total cost on the ordinate for the construction option. This figure should also include a large point on the line to indicate the breakeven point computed by the code. . The program should generate an additional proper plot (in a separate figure window) to display the profit of the construction choice with respect to time in years. This figure should also include a large point on the line to indicate the breakeven point computed by the code. Options to Evaluate The zoo has asked that you consider running your analysis for at Options to Evaluate The zoo has asked that you consider running your analysis for at least 5 years. For each construction cost, the user should be able to choose the material from a menu then manually enter all other inputs. First, the concrete has several advantages and some disadvantages. Concrete is the least expensive material with a moderate operating cost. It saves on energy costs due to its ability to insulate. However, it is also the least aesthetically appealing material and does not keep with the theme of the zoo. Because of this, fewer people will visit the enclosure, the price per ticket must be decreased, and the amount of donations will decrease. The particular details are as follows: .Name: Concrete Energy Cost: $5,000/week Operational Labor Cost: $4,000/week • Maintenance Cost: $3,000/week .Landfill Cost: $3,000/week Number of weeks per year: 50 • Number of years for analysis: 5 Admission Price: $2/person •Number of People: 9,000/week • Donations per week: $400/week Second, the wood has several advantages and some disadvantages as well. Wood keeps well with the theme of the zoo and is very attractive. Therefore, more people will want to see the enclosure at an even higher price and will be more prone to donate even more to help with the research. However, it is also the most expensive material and has a higher maintenance cost and energy cost. The particular details are as follows: • Name: Wood • Energy Cost: $10,000/week Onerational Labor Cost: $6.000/week to help with the research. However, it is also the most expensive material and has a higher maintenance cost and energy cost. The particular details are as follows: • Name: Wood - Energy Cost: $10,000/week Operational Labor Cost: $6,000/week - Maintenance Cost: $20,000/week Landfill Cost: $3,000/week Number of weeks per year: 50 •Number of years for analysis: 5 Admission Price: $3/person Number of People: 17,500/week • Donations per week: $1,000/week Finally, the adobe strikes a compromise between the other two materials. Adobe can be used to imitate wood and therefore attract more people at a higher price than concrete (though not as much as wood). It also is cheaper in material and maintenance cost wood (though not as good as concrete). The particular details are as follows: .Name: Adobe • Energy Cost: $6,000/week • Operational Labor Cost: $4,000/week • Maintenance Cost: $5,000/week • Landfill Cost: $3,000/week -Number of weeks per year: 50 Number of years for analysis: 5 • Admission Price: $2/person Number of People: 13,000/week • Donations per week: $650/week
Expert Answer:
Answer rating: 100% (QA)
ANSWER clear clc Define constants numMaterials 3 surfaceArea 3000 Create cell array for material information materials Concrete 16 30 96000 900 5 5 Wood 23 53 115000 800 12 11 Adobe 18 42 68000 600 6 ... View the full answer
Related Book For
Fundamentals of Investments
ISBN: 978-0132926171
3rd edition
Authors: Gordon J. Alexander, William F. Sharpe, Jeffery V. Bailey
Posted Date:
Students also viewed these accounting questions
-
A 0.5-m-diametcr concrete pipe (5.0 cm wall thickness with rigid pipe walls) carries water 600 m before discharging it into another reservoir. The surface elevation of the downstream reservoir is 55...
-
Please run a net present value breakeven using this original data and record the net present value level of sales here ___________. Prior to beginning this project, the company can increase the...
-
you will write a simply assembly level language program that performs few arithmetic programme
-
How many vector::push_back() operations are performed between lines 8 and 13 when this code is executed? The size of the input is the number of elements n in the vector v. Replace the question marks...
-
The following solutions are mixed: 1.0 L of 0.00010 M NaOH and 1.0 L of 0.0020 M MgSO4. Is a precipitate expected? Explain.
-
Presented below are selected transactions at Ingles Company for 2025. Jan. 1 Retired a piece of machinery that was purchased on January 1, 2015. The machine cost 58,000 on that date. It had a useful...
-
State the advantages of chain drive over belt drive. Draw neat sketches of simple and compound gear train.
-
Calculating EAC you are evaluating two different silicon wafer milling machines. The Techron I costs $330,000, has a three-year life, and has pretax operating costs of $41,000 per year. The Techron...
-
Viejol Corporation has collected the following information after its first year of sales. Sales were $1,600,000 on 100,000 units, selling expenses $250,000 (40% variable and 60% fixed), direct...
-
In Integrative Case 10.1, we projected financial statements for Walmart Stores for Years +1 through +5. The data in Chapter 12, Exhibits 12.17 through 12.19 include the actual amounts for 2015 and...
-
J, K and L have been partners for many years. J and K acquire L's partnership interest for $300,000, using their personal assets. J contributes $100,000 and K contributes $200,000 for the...
-
Twelve people serve on a board and are considering three alternatives: A, B, and C. Here are the choices followed by vote: Determine the winner, if any, using the voting methods in Problems 39-44....
-
Consider the following apportionment problem for College Town: Suppose each council member is to represent approximately 2,500 citizens. Use the apportionment plan requested in Problems 41-45...
-
Determine the winner, if any, using the voting methods in Problems \(45-50\). Seventeen people serve on a board and are considering three alternatives: A, B, and C. Here are the choices followed by...
-
The English enrollments at five high schools in the Santa Rosa Unified School District are as follows: In Problems 42-47, suppose that 45 copies of an important instructional video are to be...
-
Consider the following apportionment problem for College Town: Suppose each council member is to represent approximately 2,500 citizens. Use the apportionment plan requested in Problems 41-45...
-
Suppose a powerful labor union negotiates a wage for its members above the equilibrium wage rate in a nonunionized market. A likely result of this is that Multiple Choice the union will have...
-
The first law of thermodynamics is sometimes whimsically stated as, You cant get something for nothing, and the second law as, You cant even break even. Explain how these statements could be...
-
Given the following information, calculate the three-month price of a call that is consistent with the Black-Scholes model: Ps = $47, E = $45, R = .05. = .40
-
Some people have argued that the market portfolio can never be measured and that the CAPM, therefore, is untestable. Others have argued that APT specifies neither the number of factors nor their...
-
Dinty Barbare short sells 500 shares of Naperville Products at $45 per share. The initial margin and maintenance margin requirements are 55% and 35%, respectively. If Naperville stock rises to $50,...
-
Which of the following expenses would not appear in a cash budget? a. Depreciation expense b. Wages expense c. Interest expense d. Marketing expense
-
According to the text, which of the following factors is not one of the six Vs relating to big data? a. Variety b. Viability c. Veracity d. Vulnerability
-
The usual starting point for a direct labor budget for a manufacturer is the a. direct materials budget. b. sales budget. c. cash budget. d. production budget.
Study smarter with the SolutionInn App