Sandwich Islands, LLC has a new research and development group called SIDG.

Sandwich Islands, LLC has a new research and development group called SIDG. All systems in SIDG will run the Linux operating system and will access/share resources across SIDG’s ~500 client operating system desktops/laptops currently running Windows 7 and Windows 8.1. There is a mix of desktop and laptop systems.Current Desktop/Laptop Configuration for Windows 8.1:Processor: Intel Core i3 Second GenerationMemory: 8GB RAMHard Drive: 350GBNetwork Card: 10/100/1000 MbpsUSB Ports: 4 USB 3.0Monitor: 22-inch LCDCurrent Desktop/Laptop Configuration for Windows 7:Processor: Intel Core 2 DuoMemory: 2GB RAMHard Drive: 80GBNetwork Card: 10/100 MbpsUSB Ports: 4 USB 2.0Monitor: 17-inch LCDYour Supervisor has tasked you with a proposal to replace all Windows systems with Linux systems. You will implement the Linux variant that in your professional opinion best meets SIDG’s needs.RequirementsYour final submission should contain at least 5 to 7 pages of text (not counting title page, images, diagrams, tables, or bibliography). It must be double-spaced, have 1-inch margins, and use 12-point Times New Roman or 10-point Arial/Helvetica font. A title page is required.You must first submit your assignment to the Turnitit.com website, resolve any originality issues (defined as 40% or higher overall and any obvious non-cited sources that appear). Once you’ve deemed all originality issues resolved, submit to your assignment folder within our LEO classroom. Failure to do so may result in point deductions. Follow the TurnItIn instructions provided within the class.You must address the following in your proposal, and you may make any assumptions which are not explicitly specified (provided you adequately document these assumptions in your proposal):

Project Milestone requires the demonstration of your progress toward the completion of your final

. This Portfolio Project Milestone requires the demonstration of your progress toward the completion of your final Portfolio Project—the emphasis of this Portfolio Project Milestone is related to the “Section 1: Principle Components Discussion,” which is common to both options.Using the framework that you drafted in Module 2, add substantive content to the Section 1: Principle Components Discussion section, which describes the project management standards and processes based on the Project Management Institute’s A Guide to the Project Management Body of Knowledge® (PMBOK® Guide) (6th ed.). For each of the following items not previously completed in the Module 2 Portfolio Project Milestone, include a brief, yet substantive synopsis (1- to 3-paragraphs for each subsection level-2 bullet item):Please note that the project charter template must address the unique requirements of a small-to-medium projects in a global organization.Include the Portfolio Project option that you selected as part of the cover page, running header, and the paper titleto confirm which scenario-specific project management simulation you will complete and that aligns with your Portfolio Project option.Your Portfolio Project Milestone essay, which includes the revised Section 1: Principle Components Discussion (now expanded to approximately 4-5 pages), must include substantive, well-supported content and be formatted

Lab 5: Land Requirement of Your DietDue Week 6 and worth 30

Lab 5: Land Requirement of Your DietDue Week 6 and worth 30 pointsIn this lab, you will use a calculator to determine how much land is required to grow the food you consume.First, access the calorie counter calculator.Next, click here read “How much of the world’s land would we need in order to feed the global population with the average diet of a given country?” located at https://ourworldindata.org/agricultural-land-by-global-diets.Finally, fill out the LAB 5 JOURNAL DOCUMENT, then click the link at top to submit your completed lab journal.Lab 6: Assessing Water QualityDue Week 7 and worth 30 pointsIn this lab, you will demonstrate how water quality can be assessed by studying the effects of acid rain on different populations of aquatic invertebrates.First, access and complete Lab 6.Next, complete the LAB JOURNAL DOCUMENT, then click the link at top to submit your completed lab journal.Lab 7: Arctic Sea Ice Area in AugustDue Week 8 and worth 30 pointsIn this lab, you will calculate a linear regression of an arctic sea ice area every August from the years 1979 to 2015 in order to forecast when the artic sea ice will completely disappear. The data that you will use are found in this lab journal document.Download a copy of the lab journal document, which is a MS-Word document. Follow the instructions given in the document to carry out the analysis in Excel.Then, answer the three questions in the Lab Journal.Finally, click the link at top to submit your completed lab journal. .Lab 8: How Much Energy Do You Use?Due Week 9 and worth 30 pointsIn this lab, you will calculate the energy you use per year from sources including coal, oil, natural gas, hydroelectric, and nuclear energy.First download the LAB JOURNAL DOCUMENT, and review the instructions. Next, access and use the energy calculator to complete the lab journal document.Lastly, click the link at top to submit your completed lab journal.

Discussion 1Select a specific telecommunications law or regulation. Summarize the law/regulation and

Discussion 1Select a specific telecommunications law or regulation. Summarize the law/regulation and discuss at least one significant thing that came out of this particular law/regulation being passed.Aim for at 2-3 paragraphs for your initial discussion post. The discussion should be in your own words and reflect your understanding of the topic. Feel free to do some research on your own in order to support your post. Do not forget to cite all sources.Reading materials for this DiscussionDiscussion 2Assume you were building a new home. Your family has five computers and a printer that you want to put on a high-speed network. What kind of cabling would you use in your home? Coaxial, Cat 5e, 6, 7, fiber? Remember, it’s a new construction–so you can put in whatever you want. Why did you choose the type of cabling that you did? work on adding to the advantages or disadvantages, major uses, and/or clarifying/refining the descriptions. Reading materials for this Discussion Discussion 3There are three questions that need to be answered in the Week 3 Discussion. Please create a new thread for each discussion topic:1. Describe the functions of a hub, bridge, switch, and router. Discuss the differences between the devices. 2. Describe a LAN, MAN, and WAN. Discuss the pros/cons of each and differences.3. What is the difference between Wi-Fi and cellular? When would you use one versus the other?Reading materials for this Discussion Discussion 4….Please do some research and cite the sources usedThere are two questions that need to be answered for this Discussion. 1. Before we begin to implement any type of network solution, we need to go through a planning stage. One of the most important elements of this phase is Requirement Gathering. We need these requirements from stakeholders so we understand what is necessary to provide in order to meet all of the needs of the requestor. Assume that we are being asked to lead a project that will upgrade or replace a company’s network infrastructure. The company has 1,000 employees in two different offices and have had their existing network equipment for five years. You are leading the project and are starting the Gather Requirement activity. What requirements would you need to know about? For each requirement, who would you need to talk to get detailed clarification? Why is the Gather Requirements activity so important? 2. Understanding risk is also a vital element of network design. Risk is the chance that a threat will exploit or take advantage of a vulnerability. A threat is something that can cause harm (a hacker, a flood, etc), while a vulnerability is a weakness in a systems (poorly configured firewall, unpatched system, etc). Every time a threat can exploit a vulnerability (threat action), we have a risk. For example, there is a possibility (risk) that a disgruntled employee (threat) could delete sensitive data from the network (threat action) because of poor file system access controls (vulnerability). Choose a company or industry to examine risk for. If you currently are working, try and use your knowledge of your current company. Determine and list at least 3 risks, threats, vulnerabilities, and threat actions for your company of choice. For each risk, determine how you would mitigate the risk. Mitigation is attempting to lessen the impact or likelihood of a risk occurring.Reading materials for this Discussion Format- APA format- cite all use sources- Single spaced

1. Name Search Modify the Sorted Names program that you

Question 1. Name Search Modify the Sorted Names program that you wrote for exercises #2 so it allows you to search the array for a specific name. Need a Flowchartquestion 2 is as follow:Sorted Names Design a program that allows the user to enter 20 names into a String array. Sort the array in ascending (alphabetical) order and display its contents. Answer of question 2:Python Code: def main(): print(‘Enter 20 strings on separate lines’) SIZE = 20 lst = [] for i in range(SIZE): lst.append(input()) # sorting array here for i in range(SIZE): for j in range(SIZE-1): if lst[j] > lst[j 1]: lst[j], lst[j 1] = lst[j 1], lst[j] # display strings for i in range(SIZE): print(lst[i]) if __name__ == ‘__main__’: main()

do you believe the Universe originated?

How do you believe the Universe originated? Construct a two page, double spaced, 12 point font response to the question above. You must use a minimum of two credible sources and must provide the following information about the references you used to come to your conclusion. Please use either MLA or APA guidelines to cite your sources and in order to avoid any plagiarism! Resourceshttp://skyserver.sdss.org/dr1/en/astro/universe/universe.asphttps://www.cbsnews.com/news/7-planets-discovered-orbiting-dwarf-star-trappist-1/https://www.apa.org/education/k12/misconceptionshttps://www.theplanetstoday.com/

So I have this cash Proforma to do. I have

Question So I have this cash Proforma to do. I have the start up costs written down but from there I’m not really sure what to do next or where to start and I’m not too experienced in excel literally any help would be great. Using Microsoft Excel, construct a monthly proforma cash budget for your client for the first year of operations. Use the attached Excel Template – “Excel Assignment Diner Template” as your starting point. This is the file that must be downloaded and used as the basis for your assignment. Do not make any changes to this pre-designed template except to add your information for the diner. Do not use a template from a previous semester – this is considered academic dishonesty and will be subject to disciplinary action. Place the finished cash pro forma on a worksheet labeled “Cash ProForma”. Place all your case assumptions data on a separate worksheet. Label the worksheet “Assumptions” (note: each piece of data must appear in its own cell on the Assumption sheet). Place your start-up costs on a third worksheet labeled “Startup Costs” Create two additional worksheets for your recommendations. Label one worksheet “Beer Recommendation”, label the other “Entertainment Recommendation”. Appropriate Charts (graphs): You will be creating two separate charts so and label two additional worksheets for the charts (each chart will be in its own worksheet). Chart One -“Monthly Product Revenue” – this will show the monthly revenue for each of your five products for the entire year. Chart Two – “Total Product Net Income” – You want to track the total product net income for the year to determine any trends or projections in product sales. Make sure both charts are formatted correctly (i.e. appropriate title, legend where appropriate, data series properly labeled) and they are appropriate for business use. Calamari, Oysters, Fried shrimp, Catfish sandwiches, Salads, French fries, and sodas. Product Selling Prices: Oysters on half shell will sell for $8.25 each (dozen) Fried Shrimp will sell for $10.25 (dozen) Calamari will sell for $4.95 an order Catfish Sandwich will sell for $5.95 Salads will sell for $4.50 each Fries sell for $1.25 per order Sodas sell for $1.75 a bottle Cost of Goods Sold: The Catfish sandwich ingredients (fried catfish, cheese, sauce, bun etc.) cost $3.15 per sandwich. Calamari cost per order $1.90. The fresh Shrimp cost $7.19 per order from the supplier. Oysters (sauce, lemon, oysters) cost $5.19 per order. Salad ingredients (lettuce, tomatoes, cheese, etc.) cost $1.23 per salad serving Frozen fries and oil average to $.67 per order Sodas cost about $.7 per 16 oz. bottle The building rent is $2775 per month. Phone will cost about $220 per month. Electricity should cost about $775 a month. Insurance will be $850 a month. Advertising and promotion will be $900 a month. Operating Hours: The diner will be open seven days a week. The diner will serve lunch and dinner and will be open from 11am – 9pm on weekdays (Monday – Friday). It will need two hourly employee and an assistant manager (or manager) during these hours that the diner is open. On Saturdays the restaurant will be open 11am – 11pm and will need three hourly employees and an assistant manager (or manger). On Sundays the restaurant is only open dinner 4pm – 8pm. One hourly employee and an assistant manager will be needed during these hours.Your client will be the manager and draw a salayr2 of $48,500 per year (includes benefits). He will also work in the store during the busiest times, and fill in for the assistant manager on days off and sick days. The assistant manager will receive a 3 salary of $37,500 per year (includes benefits). The hourly workers will be paid $8.25 an hour. Monday through Fridays the owner expects an average of 15 customers an hour. Saturdays and Sundays the owner expects an average of 40 customers an hour. The restaurant is located near the beach so there is alot of foot traffic most days with Sunday being the slowest.Demand Rate: On average, 1/4 of all customer will buy shrimp, 1/4 of the customers will buy oysters, 1/4 will buy Calamari, and 1/2 customers will buy Catfish, 3/4 of them will buy a salad, all of them buy french fries, and every customer will purchase a soda. Start-up costs for the diner includes: Kitchen equipment: $16,250 Cash register and sales equipment: $1,250 Initial inventory: $5,500 Pre-opening marketing: $3,500 Diner fixtures (chairs, tables etc.): $4,500 Oil painting of your client’s momma to hang on the wall: $350 Licenses: $1,025 Security deposit: $6,500 First Insurance Payment: $850 Your client has $10,000 and plans to borrow the rest from the bank with a five-year loan at 5.1% interest. You are to calculate the monthly loan payment using the appropriate financial function. Assume a tax rate of 23% if Income Before Taxes (IBT) is equal to or is greater than $23,500. Assume a tax rate of 13% if IBT is less than $23,500. You are to calculate the monthly tax payment using the appropriate logical function. Assume that sales will grow at an average of 2.25% per month. Assume that each month contains 4.2 weeks. Scenario One: “What if” Analysis Your client is unsure if he should sell beer at the diner. He thinks he can sell a beer to every other customer and it seems to be lucrative because the beer sells for $4.75 each and costs him only $1.10 to purchase. Unfortunately your client is afraid that he would cannibalize his soft drink sales with the beer customers (one soft drink less for every beer sold). It will cost him $5,250 to purchase the beer license from the county and his monthly insurance costs would rise by another $375 per month. What is your recommendation: Should your client offer beer to his customers?4

The question is from an Intro to Computer Networks course

Question The question is from an Intro to Computer Networks course and can be seen in the screenshot below with the relevant diagram. ATTACHMENT PREVIEW Download attachment Screenshot 2019-07-09 16.54.34.png Suppose there are M paths between the server and the client. No two paths share any link. Figure 1 shows only one of the M paths, i.e. Path r’ (where i = 1, M) which consists of N links with transmission rates R‘, 12;, ij. If the server can only use one path to send to the client, what is the maximum throughput that the server can achieve? If the server can use all M paths to send data, what is the maximum throughput that the server can achieve? Server Client Figure 1. Throughput for a file transfer from server to client

List one or more unique features of Excel that make

Question List one or more unique features of Excel that make it a valuable business tool. Explain why you believe these features are valuable.

If you work in the occupational safety field, please also create the

If you work in the occupational safety field, please also create the education and certification plan for these positions in the occupational safety field including their annual safety field specialty training or emphasis. How would a safety specialist balance the typical safety field education requirements and continuing education with these additional training requirements? Also, include an estimated timeline for the completion of each requirement. Your assignment should consist of at least three pages.APA formatting is not required in this assignment; however, if you choose outside sources, please be sure to cite and reference them properly.

Python script that reads the number of seconds and convert

Question Python script that reads the number of seconds and convert it to hours, minutes and seconds.Output exampleIf 5933 is the input supplied to the program, then the output is:5933 seconds is 1 hour, 38 minutes and 53 seconds.is this code correct for this question?TIME=float(input(“input time in seconds:”))hour=TIMETIME%=3600minutes=TIMETIME%=60seconds=TIMEPrint(“%d seconds is %d hour:%d minutes and :%d seconds” %(TIME, hour, minutes, seconds))

Complete Disaster Recovery Plan to be submitted to the executive board of your company.

Develop a Complete Disaster Recovery Plan to be submitted to the executive board of your company.Only MS Word (.doc, .docx) and Adobe Acrobat (PDF) formats are acceptable. Please note that this is a formal writing, all references (peer-reviewed) mostly must be cited appropriately within the text and clearly avoid plagiarism. The paper should have a minimum of 10 pages, minimum of 2600 words, 1.5 spacing and Times New Roman font. A minimum of 5 peer review references must be provided. Reference style is APA. You can also have some web references alongside the stated requirement.

Complete Disaster Recovery Plan to be submitted to the executive board of your company.

Please see this question below ATTACHMENT PREVIEW Download attachment Screen

Question Please see this question below ATTACHMENT PREVIEW Download attachment Screen Shot 2019-07-08 at 9.29.11 PM.png 3. |Consider the following program of 1a MIPS instructions. 1w $3, Di$1l 1w $4, 4i$13 1w $5, so($s) 1w $5, 8f$13 1w $T, iﬁ($2) 1w $3, iﬁ($1) These instruction are executed on a processor with byte addressable, but word aligned memory. The promor has a 16—bit machine word. The procmsor has a onelevel 15—hlock direct—mapped cache. The cache has a block size of El bytes. Assume register $1 contains the value ﬂx34 and register 52 contains the value ﬁxﬁﬂED at the beginning of the program. {a} For each of the load instructions in the program, indicate if it would rmult in a cache hit or a cache rniss when the program is executed. [b] Draw a cache diagram indicating which block of main memory has been loaded into each block of the cache after all the above load instructions have executed. Include the index, valid, and tag columns. You do not need to show what data is contained in the blocks. {c} If a cache mim causes the MEM stage of a MIPS pipeline to take 2L

This program tests your understanding of using static methods and

Question This program tests your understanding of using static methods and println statements. You should write Java class called SixDays that should be saved into a file called SixDays.java. Your program should produce the following song as output: On the 1st day of Christmas, my true love sent to me a partridge in a pear tree. On the 2nd day of Christmas, my true love sent to me two turtle doves, and a partridge in a pear tree. On the 3rd day of Christmas, my true love sent to me three French hens, two turtle doves, and a partridge in a pear tree. On the 4th day of Christmas, my true love sent to me four calling birds, three French hens, two turtle doves, and a partridge in a pear tree. On the 5th day of Christmas, my true love sent to me five golden rings, four calling birds, three French hens, two turtle doves, and a partridge in a pear tree. On the 6th day of Christmas, my true love sent to me six geese a-laying, five golden rings, four calling birds, three French hens, two turtle doves, and a partridge in a pear tree. The song is a modified version of a classic holiday song. For brevity, we reduced the number of days from the original twelve to six. You should exactly reproduce the format of this output. This includes having identical wording, spelling, spacing, punctuation, and capitalization. Please do not include additional verses, such as writing twelve days to match the complete song. You may include a blank line at the very end of the output if you like. One way to do this program would be to simply put a println statement that outputs each line of the song in order. However, such a solution would not receive full credit. Part of the challenge of this assignment lies in recognizing the structure and redundancy of the song and improving the code using static methods. Stylistic Guidelines: You should not place any println statements in your main method. (It is okay for main to have empty println statements to print blank lines.) Instead of printing in main, use static methods for two reasons: 1. To capture the structure of the song’s six verses. You should write static methods to capture the structure of the song. You should, for example, have a method for each of the six verses of the song to print that verse’s entire contents. 2. To avoid simple redundancy in the output. You should use only one println statement for each distinct non-blank line of the song. For example, the following line appears several times in the output, but you should have only one println statement in your program that prints that line of the song: a partridge in a pear tree. However, a method that prints a single line such as the above is not useful. Instead, you should identify groups of two or more lines that appear in multiple places in the song and create static methods that capture those groups and are called multiple times. There is a general structural redundancy to the song that you should eliminate with your static methods. Recall that methods can call other methods if necessary. The key question to ask yourself is whether or not you have repeated lines of code that could be eliminated if you structured your static methods differently. As a point of reference, our solution to this program has twelve static methods other than main and occupies 89 lines including comments and blank lines. You do NOT have to eliminate redundancy in lines that are similar but not identical, such as these: On the 1st day of Christmas, my true love sent to me On the 2nd day of Christmas, my true love sent to me It is not possible to avoid this partial-line redundancy using just what we have learned so far (static methods and simple println statements), so you are not expected to eliminate it. Include a comment at the beginning of your program with some basic information and a description of the program. The comments in your program should be written in own and not copied from this document. You must comment every line and the comment should explain what the code does and not simply what it outputs.

For IT213-Unit5 Assignment3.Unit 5 Assignment 3: Coding ProjectWrite code that

Question For IT213-Unit5 Assignment3.Unit 5 Assignment 3: Coding ProjectWrite code that accurately reflects the flowchart shown below.EXPECTED OUTPUTOUTPUT:2468101214161820I have checked the solution and when entered it does not give the correct output. It only goes up to 10. The only way for me to get that output is to change Count <= 20, but the flowchart indicates Count <= 10. Also, I'm not entirely sure how to use both Count and Number, as in my code I'm able to code it without using both Number and Count. ATTACHMENT PREVIEW Download attachment flowchart.PNG

the knowledge, skills, or theories of this course(Application Security) have been applied, or could be applied, in a practical manner to your current work environment.

Assignment: Provide a reflection of at least 2 pages, double spaced of how the knowledge, skills, or theories of this course(Application Security) have been applied, or could be applied, in a practical manner to your current work environment. If you are not currently working, share times when you have or could observe these theories and knowledge could be applied to an employment opportunity in your field of study. The assignment is worth 100 points. Requirements:

I need helping filling the table based on the circuit

Question I need helping filling the table based on the circuit src=”/qa/attachment/8341741/” alt=”1.PNG” /> Attachment 1 Attachment 2 ATTACHMENT PREVIEW Download attachment 1.PNG ATTACHMENT PREVIEW Download attachment 2.PNG

What is a good response to the following post? Hello

Question What is a good response to the following post? Hello professor

Any help will be greatly appreciated. I have set up

Question Any help will be greatly appreciated. I have set up the fixed costs but I am not sure where to go from there. Please any help is greatly appreciated. Using Microsoft Excel, construct a monthly proforma cash budget for your client for the first year of operations. Use the attached Excel Template – “Excel Assignment Diner Template” as your starting point. This is the file that must be downloaded and used as the basis for your assignment. Do not make any changes to this pre-designed template except to add your information for the diner. Do not use a template from a previous semester – this is considered academic dishonesty and will be subject to disciplinary action. Place the finished cash pro forma on a worksheet labeled “Cash ProForma”. Place all your case assumptions data on a separate worksheet. Label the worksheet “Assumptions” (note: each piece of data must appear in its own cell on the Assumption sheet). Place your start-up costs on a third worksheet labeled “Startup Costs” Create two additional worksheets for your recommendations. Label one worksheet “Beer Recommendation”, label the other “Entertainment Recommendation”. Appropriate Charts (graphs): You will be creating two separate charts so and label two additional worksheets for the charts (each chart will be in its own worksheet). Chart One -“Monthly Product Revenue” – this will show the monthly revenue for each of your five products for the entire year. Chart Two – “Total Product Net Income” – You want to track the total product net income for the year to determine any trends or projections in product sales. Make sure both charts are formatted correctly (i.e. appropriate title, legend where appropriate, data series properly labeled) and they are appropriate for business use. Calamari, Oysters, Fried shrimp, Catfish sandwiches, Salads, French fries, and sodas. Product Selling Prices: Oysters on half shell will sell for $8.25 each (dozen) Fried Shrimp will sell for $10.25 (dozen) Calamari will sell for $4.95 an order Catfish Sandwich will sell for $5.95 Salads will sell for $4.50 each Fries sell for $1.25 per order Sodas sell for $1.75 a bottle Cost of Goods Sold: The Catfish sandwich ingredients (fried catfish, cheese, sauce, bun etc.) cost $3.15 per sandwich. Calamari cost per order $1.90. The fresh Shrimp cost $7.19 per order from the supplier. Oysters (sauce, lemon, oysters) cost $5.19 per order. Salad ingredients (lettuce, tomatoes, cheese, etc.) cost $1.23 per salad serving Frozen fries and oil average to $.67 per order Sodas cost about $.7 per 16 oz. bottle The building rent is $2775 per month. Phone will cost about $220 per month. Electricity should cost about $775 a month. Insurance will be $850 a month. Advertising and promotion will be $900 a month. Operating Hours: The diner will be open seven days a week. The diner will serve lunch and dinner and will be open from 11am – 9pm on weekdays (Monday – Friday). It will need two hourly employee and an assistant manager (or manager) during these hours that the diner is open. On Saturdays the restaurant will be open 11am – 11pm and will need three hourly employees and an assistant manager (or manger). On Sundays the restaurant is only open dinner 4pm – 8pm. One hourly employee and an assistant manager will be needed during these hours.Your client will be the manager and draw a salayr2 of $48,500 per year (includes benefits). He will also work in the store during the busiest times, and fill in for the assistant manager on days off and sick days. The assistant manager will receive a 3 salary of $37,500 per year (includes benefits). The hourly workers will be paid $8.25 an hour. Monday through Fridays the owner expects an average of 15 customers an hour. Saturdays and Sundays the owner expects an average of 40 customers an hour. The restaurant is located near the beach so there is alot of foot traffic most days with Sunday being the slowest.Demand Rate: On average, 1/4 of all customer will buy shrimp, 1/4 of the customers will buy oysters, 1/4 will buy Calamari, and 1/2 customers will buy Catfish, 3/4 of them will buy a salad, all of them buy french fries, and every customer will purchase a soda. Start-up costs for the diner includes: Kitchen equipment: $16,250 Cash register and sales equipment: $1,250 Initial inventory: $5,500 Pre-opening marketing: $3,500 Diner fixtures (chairs, tables etc.): $4,500 Oil painting of your client’s momma to hang on the wall: $350 Licenses: $1,025 Security deposit: $6,500 First Insurance Payment: $850 Your client has $10,000 and plans to borrow the rest from the bank with a five-year loan at 5.1% interest. You are to calculate the monthly loan payment using the appropriate financial function. Assume a tax rate of 23% if Income Before Taxes (IBT) is equal to or is greater than $23,500. Assume a tax rate of 13% if IBT is less than $23,500. You are to calculate the monthly tax payment using the appropriate logical function. Assume that sales will grow at an average of 2.25% per month. Assume that each month contains 4.2 weeks. Scenario One: “What if” Analysis Your client is unsure if he should sell beer at the diner. He thinks he can sell a beer to every other customer and it seems to be lucrative because the beer sells for $4.75 each and costs him only $1.10 to purchase. Unfortunately your client is afraid that he would cannibalize his soft drink sales with the beer customers (one soft drink less for every beer sold). It will cost him $5,250 to purchase the beer license from the county and his monthly insurance costs would rise by another $375 per month. What is your recommendation: Should your client offer beer to his customers?4