A company wants to prepare a profit/loss report in a tabular form. The company has 4...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A company wants to prepare a profit/loss report in a tabular form. The company has 4 different business areas namely Marketing, Advertising, Production and Information Technology (1 Tech). There are 25 branches in the company in different cities and each branch has all 4 business areas named above. Each branch's business performance is given to you in a comma separated list. Example is shown below: Austin TX, 70000, 182000, -56000, 39803 Houston TX, -67000, 256000, 172000, 11223 Data of all branches (in the above format) is given to you in a file named business performance.dat. Write a bash script to open and read the file business_performance.dat line by line and then prints each branch's business revenues as shown in the example below. A title as shown and the report print data also must be shown. The Location Austin TX Houston TX Global Traders Inc Business Performance Report by Location/Business Area Report Date Thu, Sep 10, 2020 9:22:01 PM Aurora IL Augusta GA Totals Marketing Advertising Production I. Tech 70000.00 182000.00 -56000.00 39803.00 -67000.00 256000.00 172000.00 11223.00 Once the revenues are printed as shown above, you must also total each column including the Total Revenue column and then printed as shown in the de -39949.00 -399499.00 -28888.00 838833.00 22922.00 49393.00 3093025.00 Total Revenue 235803.00 372223.00 389824.00 -78512.00 -292893.00 618255.00 5971906.00 2799894.00 248287.00 -169300.00 Profit or lost is based on forecasted revenues for each business area is given below: Marketing Advertising Production | Tech Total Revenue Forecasted Revenue 3000000.00 2500000.00 400000.00 200000.00 7500000.00 Each area's (including Total Revenue) profit or loss is calculated by: Profit/Loss = Total Revenue - Forecasted Revenue Based on that the profit or loss for the company is displayed as shown below. Forecasted Profit/Loss (-) Shown below is an actual run. Location Austin TX Houston TX San Antonio TX Los Angeles CA Pheonix AZ Seattle WA Denver Co Global Traders Inc. Business Performance Report by Location/Business Areal Report Date Thu, Sep 10, 2020 9:22:01 PM Marketing Advertising Production I. Tech Charlotte NC Jacksonville FL Boston MA Detroit MI Memphis TN Kansas City MO Miami FL Tulsa OK Omaha NB Lexington KY Henderson NV Jersey City NJ Madison WI Boise ID Modesto CA Rochester NY Aurora IL Augusta GA Totals 3000000.00 2500000.00 400000.00 200000.00 7500000.00 93025.00 299894.00 -151713.00 -369300.00 -1528094.00 Forecasted Profit/Loss(-) 70000.00 182000.00 -67000.00 256000.00 105600.00 89000.00 260000.00 302000.00 -67000.00 178000.00 56777,00 73287.00 -67000.00 22209.00 105600,00 89000.00 -38833.00 228989.00 323234.00 -188338.00 -49884.00 -290292.00 28829.00 383883.00 292902.00 39393.00 49943.00 123333,00 55444.00 38838,00 -199292.00 388383.00 488383.00 23939.00 88828.00 49949.00 38383.00 399349.00 100292.00 93933.00 -398983.00 423993.00 39803.00 -56000.00 172000.00 11223.00 37723.00 102000.00 -45000.00 7847.00 23209.00 234782.00 298429.00 489994.00 22902.00 -39949.00 -399499.00 838833.00 22922.00 3093025.00 2799894.00 3000000.00 2500000.00 93025.00 299894.00 33323.00 -199393.00 34000.00 -110000.00 17891,00 -19911.00 92892.00 33321.00 81422.00 33234.00 189001.00 9939.00 2992.00 235803.00 372223.00 334323.00 -89000.00 428000.00 35000.00 128044.00 314001.00 389943.00 -199133.00 -70653.00 -29933.00 -178781.00 468071.00 2122.00 44344.00 135802.00 -199239,00 -99233.00 -119695.00 -399393,00 177233.00 -382614.00 83838.00 306151.00 2882.00 590032.00 -10901.00 65979,00 49499.00 -199123.00 288108.00 81818.00 -38833.00 -19929.00 1671.00 29849.00 -2992.00 89239.00 494933.00 1117383.00 393933.00 -292922.00 613907.00 -28888.00 389824.00 -78512.00 49393.00 -292893.00 618255.0 848287.00 -169300.00 5971906.00 400000.00 0.00 7500000,00 -151713.00 Total Revenue 369300.00 Company Title 237210.00 6752.00 57913.00 Date. Must print the current date. Not a hardcoded All numbers must be right aligned and 2 places precision print the current date. Not a hardcoded All dotted lines must be drawn as shown. These two rows and the right most column must be calculated A company wants to prepare a profit/loss report in a tabular form. The company has 4 different business areas namely Marketing, Advertising, Production and Information Technology (1 Tech). There are 25 branches in the company in different cities and each branch has all 4 business areas named above. Each branch's business performance is given to you in a comma separated list. Example is shown below: Austin TX, 70000, 182000, -56000, 39803 Houston TX, -67000, 256000, 172000, 11223 Data of all branches (in the above format) is given to you in a file named business performance.dat. Write a bash script to open and read the file business_performance.dat line by line and then prints each branch's business revenues as shown in the example below. A title as shown and the report print data also must be shown. The Location Austin TX Houston TX Global Traders Inc Business Performance Report by Location/Business Area Report Date Thu, Sep 10, 2020 9:22:01 PM Aurora IL Augusta GA Totals Marketing Advertising Production I. Tech 70000.00 182000.00 -56000.00 39803.00 -67000.00 256000.00 172000.00 11223.00 Once the revenues are printed as shown above, you must also total each column including the Total Revenue column and then printed as shown in the de -39949.00 -399499.00 -28888.00 838833.00 22922.00 49393.00 3093025.00 Total Revenue 235803.00 372223.00 389824.00 -78512.00 -292893.00 618255.00 5971906.00 2799894.00 248287.00 -169300.00 Profit or lost is based on forecasted revenues for each business area is given below: Marketing Advertising Production | Tech Total Revenue Forecasted Revenue 3000000.00 2500000.00 400000.00 200000.00 7500000.00 Each area's (including Total Revenue) profit or loss is calculated by: Profit/Loss = Total Revenue - Forecasted Revenue Based on that the profit or loss for the company is displayed as shown below. Forecasted Profit/Loss (-) Shown below is an actual run. Location Austin TX Houston TX San Antonio TX Los Angeles CA Pheonix AZ Seattle WA Denver Co Global Traders Inc. Business Performance Report by Location/Business Areal Report Date Thu, Sep 10, 2020 9:22:01 PM Marketing Advertising Production I. Tech Charlotte NC Jacksonville FL Boston MA Detroit MI Memphis TN Kansas City MO Miami FL Tulsa OK Omaha NB Lexington KY Henderson NV Jersey City NJ Madison WI Boise ID Modesto CA Rochester NY Aurora IL Augusta GA Totals 3000000.00 2500000.00 400000.00 200000.00 7500000.00 93025.00 299894.00 -151713.00 -369300.00 -1528094.00 Forecasted Profit/Loss(-) 70000.00 182000.00 -67000.00 256000.00 105600.00 89000.00 260000.00 302000.00 -67000.00 178000.00 56777,00 73287.00 -67000.00 22209.00 105600,00 89000.00 -38833.00 228989.00 323234.00 -188338.00 -49884.00 -290292.00 28829.00 383883.00 292902.00 39393.00 49943.00 123333,00 55444.00 38838,00 -199292.00 388383.00 488383.00 23939.00 88828.00 49949.00 38383.00 399349.00 100292.00 93933.00 -398983.00 423993.00 39803.00 -56000.00 172000.00 11223.00 37723.00 102000.00 -45000.00 7847.00 23209.00 234782.00 298429.00 489994.00 22902.00 -39949.00 -399499.00 838833.00 22922.00 3093025.00 2799894.00 3000000.00 2500000.00 93025.00 299894.00 33323.00 -199393.00 34000.00 -110000.00 17891,00 -19911.00 92892.00 33321.00 81422.00 33234.00 189001.00 9939.00 2992.00 235803.00 372223.00 334323.00 -89000.00 428000.00 35000.00 128044.00 314001.00 389943.00 -199133.00 -70653.00 -29933.00 -178781.00 468071.00 2122.00 44344.00 135802.00 -199239,00 -99233.00 -119695.00 -399393,00 177233.00 -382614.00 83838.00 306151.00 2882.00 590032.00 -10901.00 65979,00 49499.00 -199123.00 288108.00 81818.00 -38833.00 -19929.00 1671.00 29849.00 -2992.00 89239.00 494933.00 1117383.00 393933.00 -292922.00 613907.00 -28888.00 389824.00 -78512.00 49393.00 -292893.00 618255.0 848287.00 -169300.00 5971906.00 400000.00 0.00 7500000,00 -151713.00 Total Revenue 369300.00 Company Title 237210.00 6752.00 57913.00 Date. Must print the current date. Not a hardcoded All numbers must be right aligned and 2 places precision print the current date. Not a hardcoded All dotted lines must be drawn as shown. These two rows and the right most column must be calculated
Expert Answer:
Answer rating: 100% (QA)
SOLUTION CODE binbash Here tput cols gives us the number of columns in the current terminal and numb... View the full answer
Related Book For 
Mathematical Applications for the Management Life and Social Sciences
ISBN: 978-1305108042
11th edition
Authors: Ronald J. Harshbarger, James J. Reynolds
Posted Date:
Students also viewed these mathematics questions
-
A company wants to have $800,000 for office renovations. If it can deposit $40,000 at the beginning of each quarter into an account that earns 5.2% compounded quarterly, how long before the company...
-
A company wants to select no more than 2 projects from a set of 4 possible projects. Which of the following constraints ensures that no more than 2 will be selected? Select one: A. X1 + X2 + X3 + X4...
-
A company wants to offer health care funding of $25,000 for its employees at retirement. The employer faces a current marginal tax rate of 21% (in year 1) but expects it will face a 28% in the next...
-
Hemming Co. reported the following current year purchases and sales for its only product. Required Hemming uses a perpetual inventory system. Determine the costs assigned to ending inventory and to...
-
Magnetic particle clutches are useful actuator devices for high power requirements because they can typically provide a 200-W mechanical power output. The particle clutches provide a high...
-
Hambelton Ltd. issued $4,000,000 of 5% bonds payable on 1 September 20X9 to yield 4%. Interest on the bonds is paid semi-annually and is payable each 28 February and 31 August. The bonds were dated 1...
-
Standard atmospheric air \(\left(T_{0}=59^{\circ} \mathrm{F}, p_{0}=14.7 \mathrm{psia} ight)\) is drawn steadily through a frictionless and adiabatic converging nozzle into an adiabatic, constant...
-
Eureka Limited has a calendar-year accounting period. The following errors were discovered in 2014. 1. The December 31, 2012 merchandise inventory had been understated by $51,000. 2. Merchandise...
-
Discuss the relationship between sustainability and corporate social responsibility (CSR), addressing how companies can integrate sustainability goals into their business strategies, stakeholder...
-
The accounts in the ledger of Time Is Money Delivery Service contain the following balances on July 31, 2015. Accounts Receivable ......... $10,642 Prepaid Insurance ............ $ 1,968 Accounts...
-
How strategic planning in healthcare related to resource allocation?
-
Write ARM assembly language code that handles a breakpoint. It should save the necessary registers, call a subroutine to communicate with the host, and upon return from the host, cause the...
-
Study the Heisenberg model of a ferromagnet, based on the interaction (12.3.6), in the mean field approximation and show that this also leads to a phase transition of the kind met in the Ising model....
-
While working for a space agency, you are tasked with ensuring that the oxygen needs of human beings on long voyages in outer space are met. Your boss hands you a data table and suggests that you...
-
Have you ever written a programming assignment with an error in the specifications? If so, at what point did you catch the error? How damaging was the error to your design and code?
-
Unless otherwise specified, which rule will always be processed?
-
Required information [The following information applies to the questions displayed below.) Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales...
-
You are a U.S. investor who purchased British securities for 2,000 one year ago when the British pound cost U.S. $1.50. What is your total return (based on U.S. dollars) if the value of the...
-
A retired couple have $150,000 to invest and want to earn $15,000 per year in interest. The safer investment yields 9.5%, but they can supplement their earnings by investing some of their money at...
-
Suppose a government study estimated that the probability of successive generations of a rural family remaining in a rural area was 0.7 and the probability of successive generations of an urban...
-
A baseball pitching machine throws a bad pitch with probability 0.1. What is the probability that the machine will throw 5 or fewer bad pitches out of 20 pitches?
-
The U-tube in Fig. P2.160 rotates at \(2.0 \mathrm{rev} / \mathrm{sec}\). Find the absolute pressures at points \(C\) and \(B\) if the atmospheric pressure is 14.696 psia. Recall that \(70{ }^{\circ}...
-
A valve has a failure rate of 0.06 failures per year. A periodic inspection performed once a year can detect 60% of the failures. The valve is operated for 10 years before it is removed from service...
-
An instrument has a failure rate of 0.015 failures per year. All failures are immediately detectable. The MTTR is 24 hours. What is steady state unavailability?
Study smarter with the SolutionInn App