For this assignment, you will be analyzing the Java™ code in the linked Week 3 Analyze Assignment Zip File, and predicting the results. You will also examine both the code and the output for inconsistencies and clarity. This Java™ code includes examples of for, while, and do-while loops.

Carefully read through the code line by line, then answer the following questions in a Microsoft^® Word document:

1. What is the output of the program as it is written?
2. What improvement(s) could be made to this code to make the output clearer or more accurate, or to make the code easier to maintain?

Note: You do not have to make the improvements in the Java™ program, although you certainly may. For this assignment, simply describe the things you see that would need to be improved to elevate the code and output to a more professional level. For the code, consider variable names and hardcoding. For the output, consider formatting/punctuation, repetition, accuracy of information, and wording.

/**************************************************************************************
* Program: PRG/420 Week 3
* Purpose: Week 3 Analyze Assignment
* Programmer: Iam A. Student   
* Class: PRG/420   
* Creation Date: 10/22/17
******************************************************************************************
* Program Summary: For, while, and do-while loops
*
* This program demonstrates the syntax for the for, while, and do-while loops. It also
* contains comments that explain why a programmer would use a for loop over a while or do-while
* loop.
*
* Notice the increment operator (i++) and also notice the copious use of println() statements.
* Using System.out.println() is an excellent way to debug your code--especially if your loop code
* is giving unexpected results.
*****************************************************************************************/

package PRG420Week3_AnalyzeAssignment;

public class PRG420Week3_AnalyzeAssignment {

public static void main(String[] args) {
  
// for loops are a good choice when you have a specific number of values
// you want to iterate over and apply some calculation to.
System.out.println("FOR LOOP - Here are the taxes on all 10 prices:");
  
double taxRate = 0.08;
for (int price=1; price<=10; price++) {
System.out.println("The 8% tax on " + price + " dollar(s) is " + "$" + (price * taxRate));
}
System.out.println(""); // Leave a blank space
  
// while loops are a good choice when you're looking through a pile of values
// and want to execute some logic while some condition is true.
// while loops MAY OR MAY NOT EVER EXECUTE, depending on the counter value.
int dollars=1;
System.out.println("WHILE LOOP - Here are the taxes on prices less than $5:");
while (dollars < 5) {
System.out.println("The 8% tax on " + dollars + " dollar(s) is $" + (dollars * taxRate));
dollars++;
}
System.out.println(""); // Leave a blank space
  
// do-while loops are also a good choice when you're looking through a pile of values
// and want to execute some logic while some condition is true.
// do while loops ALWAYS EXECUTE AT LEAST ONCE, no matter what the counter value.
// For example, in the code below, we want to print out the tax only on those
// amounts smaller than $1. But because we're using the do-while loop, the code
// will execute the body of the loop once before it even checks the condition! So
// we will get an INCORRECT PRINTOUT.
dollars=1;
  
System.out.println("DO-WHILE LOOP - Here are the taxes on prices less than $1:");
  
do {
System.out.println("The 8% tax on " + dollars + " dollar(s) is $" + (dollars * 0.08));
dollars++;
} while (dollars < 1);
}
}

For this assignment, you can build on the 9^th exercise that you made for the Assignment 1. So, you have a file named “band.html”.

1. Create 2 more web pages besides band.html. All have to be in the same folder.
2. You can redesign your band.html web page.
3. Name each file as you wish (e.g., album names, tour, contact). They should also appear in the navigation bar. You can name your home page as Home in the navigation bar.
4. Create an external style sheet named “band.css” in the same folder. You should configure all the styling in this file and create a link in your all 3 web pages.
5. You should use all the properties below in your band.css file at least once:
   • background-color (use only hexadecimal color values)
   • color (use only hexadecimal color values)
   • font-family
   • font-size
   • font-style
   • font-weight
   • letter-spacing
   • line-height
   • text-align
   • text-decoration
   • text-indent
   • text-shadow
   • text-transform
   • width
   • word-spacing
6. Use all the selectors (body, h1, h2, nav, nav a, p, ul, and footer) available in Figure 3.20 on page 108 in your textbook.
7. Center all 3 web pages’ content with 80% width.
8. Your navigation bar should contain links to all three pages, and when you click on any of the pages, it should transfer you to the web page.

Here is the band.html page that I did in the last assignment that this assignment starts off with:

<!DOCTYPE html>

<html lang="en">

<head>

<title>Assignment One</title>

<meta charset="utf-8">

</head>

<body>

<!--HTML to display name with largest heading element -->

<h1>My Name</h1>

<hr>

<!-- absolute link to school website -->

<a href="https://www.uncg.edu/">UNCG</a>

<hr>

<!--Unordered list to display days of the week -->

<h3>Week Days</h3>

<ul>

<li>Sunday</li>

<li>Monday</li>

<li>Tuesday</li>

<li>Wednesday</li>

<li>Thursday</li>

<li>Friday</li>

<li>Saturday</li>

</ul>

<hr>

<!--4 -->

<h3>Ordered List</h3>

<!--Ordered list -->

<ol type="A">

<li>HTML</li>

<li>XML</li>

<li>XHTML</li>

</body>

</html>

Website Section

<!DOCTYPE html>

<html lang="en">

<head>

<!--title for web page -->

<title>My Favorite Musical Group</title>

<meta charset="UTF-8">

<meta name="viewport" content="width=device-width, initial-scale=1">

</head>

<body>

<h1>My Favorite Musical Group: Old Dominion</h1>

<h3>Group Members:</h3>

<!-- Unordered list -->

<ul>

<li>Matthew Ramsey</li>

<li>Trevor Rosen</li>

<li>Brad Tursi</li>

<li>Geoff Sprung</li>

<li>Whit Sellers</li>

</ul>

<h3>Albums:</h3>

<!--Description List -->

<dl>

<li>Happy Endings (2017) - This album is my favorite of all their albums. It contains some well-known songs, such as "No Such Thing as a Broken Heart," "Hotel Key," and "Written in the Sand." </li>

<li>Meat and Candy (2015) - This album was their first album and it really set the tone for the rest of their music to come. It was an overall very vocally strong album. </li>

</ol>

<hr>

<!--hyperlink -->

click here for <a href="https://www.weareolddominion.com/">more details</a>

</body>

</html>

Module 1 Program

Write a complete Java program in a file called Module1Program.java that reads all the lyrics from a file named lyrics.txt that is to be found in the same directory as the running program. The program should read the lyrics for each line and treat each word as a token. If the line contains a double (an integer is also treated as a double) it should use the first double it finds in line as the timestamp for the line. Treat the first line so that it has a timestamp of 0.00. The last line of the lyrics will have a timestamp. All the timestamps will be in double format. If a line has more than one timestamp, use the first timestamp found searching left to right for the outpt timestamp of that line. Some lines may not contain an embedded timestamp. Interpolate the timestamp so that it is evenly spaced from the preceding line that has a timestamp to next line which also has a timestamp. When displaying the output, display the timestamp for the line as double with 2 places past the decimal place. For example if lyrics.txt contains

Ay
Fonsi
5.02 DY
Oh, oh no, oh no
Oh, yeah
Diridiri, dirididi Daddy
Go
Si, sabes que ya llevo un rato mirandote
Tengo que bailar 10.4  contigo hoy (DY)
Vi que tu 12 mirada 12.1 ya estaba llamandome
Muestrame el camino que yo voy (oh)
Tu, tu eres el iman y yo soy el metal
Me voy acercando y 15.5 voy armando el plan

Then your program should print to the screen

0.00 Ay
2.51 Fonsi
5.02 DY
5.92 Oh, oh no, oh no
6.81 Oh, yeah
7.71 Diridiri, dirididi Daddy
8.61 Go
9.50 Si, sabes que ya llevo un rato mirandote
10.40 Tengo que bailar contigo hoy (DY)
12.00 Vi que tu mirada ya estaba llamandome
13.17 Muestrame el camino que yo voy (oh)
14.33 Tu, tu eres el iman y yo soy el metal
15.50 Me voy acercando y voy armando el plan

1. If the file does not exist, then your program should instead display, “File not found” and exit.
2. If the lyrics.txt contains more than 200 lines, it should display, “The song is too long” and exit.
3. If the lyrics file is empty, the program should display, “Empty file” and exit.

A little starter code:

import java.io.File;
import java.io.FileNotFoundException;
import java.util.Scanner;

/**
 * Program that reads lyrics from file lyrics.txt and prints the lyrics
 * with a timestamp to the left of each line

public class Module1Program {
    
    public static final int NUM_LINES = 200;
    

    public static void main(String[] args) {
        File theSong = new File("lyrics.txt");
        Scanner input;
        
        try {
            input = new Scanner(theSong);
        } catch (FileNotFoundException e) {
            System.out.println("File not found");
            return;
        }
        
        while (input.hasNextLine()) {
            System.out.println(input.nextLine());
        }
        
        input.close();
    }

}

Make sure that your program does not have a Package.

Testing: You should test your program in a variety of situations – missing file, empty file, file too long, file with only one timestamp, file with multiple timestamps per line.

Please use python3

Create the function team_average which has the following header

def team_average(filename):

This function will return the average number of games won by the Red Sox from a text file with entries like this

2011-07-02      Red Sox @  Astros       Win 7-5
2011-07-03      Red Sox @  Astros       Win 2-1
2011-07-04      Red Sox vs Blue Jays    Loss 7-9

This function should create a file object for the file whose name is given by the parameter filename.

If the file cannot be opened, use a try/except statement to print an error message and don't do any further work on the file.

The function will count the number of lines and the number of games the Red Sox won and use these values to compute the average games won by the team.

This average should be expressed as an integer.

Test Code

Your hw2.py file must contain the following test code at the bottom of the file

team_average('xxxxxxx')
print(team_average('red_sox.txt'))

For this test code to work, you must copy into your hw2 directory the file red_sox.txt from /home/ghoffman/course_files/it117_files.

To do this go to your hw2 directory and run cp /home/ghoffman/course_files/it117_files/red_sox.txt .

Suggestions

Write this program in a step-by-step fashion using the technique of incremental development.

In other words, write a bit of code, test it, make whatever changes you need to get it working, and go on to the next step.

1. Create the script hw2.py using nano or some other Unix text editor.
   Enter the header for team_average into the script.
   Under this header write the Python statement pass.
   Copy the test code above into the script.
   Make the script executable.
   Run the script.
   If all you see is None, proceed to the text step.
2. Remove the pass statement.
   In its place write the function code to open the file for reading.
   This code should print an error message and exit the function if the file cannot be opened for reading.
   Run the script.
   You should see

   Cannot open xxxxxxx
   None

3. Modify the function so it prints out the lines of the file.
4. Modify the function to use the split string method to create a list from the from the different fields in a line. Print this list.
5. For each line, get the value of the won_lost field and print it.
   This field is second to last entry in the list you created by using the split method.
   The lists will have different lengths, since some team have a single word as their name, and others have two words, e.g. White Sox.
   The easiest way to get the second to last field is to use a negative index.
   Print the value of won_lost field.
6. Comment out or delete the line that prints the won_lost field.
   Initialize an accumulator to count the number of lines.
   Increment this accumulator inside the for loop.
   Return the total number of lines.
7. Initialize an accumulator to count the number of Red Sox wins.
   In the for loop increment this accumulator every time the value of won_lost is "Win".
   Return the number of games won.
8. Change the return statement so it returns integer percent of the number of games the Sox won.

Output

When you run the completed script, you should see

Error: Unable to open xxxxxxx
76

Below is what I have to do. This is all performed in SQL. I have written a bunch of code, that I have also provided. Any help is appreciated

Exercises

Complete each of the following exercises. If you are unsure how to accomplish the task, please consult the coursework videos where there are explanations and demos.

1. Use built in SQL functions to write an SQL Select statement on fudgemart_products which derives a product_category column by extracting the last word in the product name. For example
   1. for a product named ‘Leather Jacket’ the product category would be ‘Jacket’
   2. for a product named ‘Straight Claw Hammer’ the category would be ‘Hammer’

Your select statement should include product id, product name, product category and product department.

2. Write a user defined function called f_total_vendor_sales which calculates the sum of the wholesale price * quantity of all products sold for that vendor. There should be one number associated with each vendor id, which is the input into the function. Demonstrate the function works by executing an SQL select statement over all vendors calling the function.
   
3. Write a stored procedure called p_write_vendor which when given a required vendor name, phone and optional website, will look up the vendor by name first. If the vendor exists, it will update the phone and website. If the vendor does not exist, it will add the info to the table. Write code to demonstrate the procedure works by executing the procedure twice so that it adds a new vendor and then updates that vendor’s information.
   
4. Create a view based on the logic you completed in question 1 or 2. Your SQL script should be programmed so that the entire script works every time, dropping the view if it exists, and then re-creating it.
   
5. Write a table valued function f_employee_timesheets which when provided an employee_id will output the employee id, name, department, payroll date, hourly rate on the timesheet, hours worked, and gross pay (hourly rate times hours worked).

Written Code

use fudgemart_v3
go

--Question 1
--This runs but doesn't supply correct output
select * from fudgemart_products
select right(product_name, charindex(' ', product_name)) as product_category from fudgemart_products
go

---Runs but returns NULL for product_Category
select product_id, product_name, product_department
from fudgemart_products
order by product_id
declare @product_name as varchar(20)
select right(@product_name, charindex(' ',@product_name)) as product_category

print len(@product_name)

---question 2-----

drop function dbo.f_vendor_sales
go

declare @vendor_id int
set @vendor_id = 1
select count(*) from fudgemart_products where product_vendor_id = @vendor_id
go

--Function says it is completed
create function dbo.f_total_vendor_sales(
   @vendor_id int --input
   ) returns int as
begin
   declare @count int
   set @count = (select count(*) from fudgemart_products.dbo.product_wholesale_price where product_vendor_id = @vendor_id)
   return @count --output
end
go

---When i attempt function, I get invalid object name

select product_vendor_id, product_wholesale_price,
   dbo.f_total_vendor_sales(product_vendor_id) as total_vendor_sales
   from fudgemart_products

----For question 3-------
create procedure p_write_vendor
(
   @vendor_name varchar (50),
   @vendor_phone varchar (20),
   @vendor_website varchar (100)
   ) as
if exists ( select 1 from fudgemart_vendors
               where vendor_name = @vendor_name
               or vendor_phone = @vendor_phone
               or vendor_website = @vendor_website)
   begin
       update fudgemart_vendors
       set vendor_name =@vendor_name,
           vendor_phone = @vendor_phone,
           vendor_website = @vendor_website
       where vendor_name = @vendor_name
       or vendor_phone = @vendor_phone
       or vendor_website = @vendor_website
   end
else
   begin
       insert into fudgemart_vendors values (@vendor_name, @vendor_phone, @vendor_website)
   end

Exotic Food Inc., a food processing company located in Herndon, VA, is considering adding a new division to produce fresh ginger juice. Following the ongoing TV buzz about significant health benefits derived from ginger consumption, the managers believe this drink will be a hit. However, the CEO questions the profitability of the venture given the high costs involved. To address his concerns, you have been asked to evaluate the project using three capital budgeting techniques (i.e., NPV, IRR and Payback) and present your findings in a report.

CASE OVERVIEW

The main equipment required is a commercial food processor which costs $200,000. The shipping and installation cost of the processor from China is $50,000. The processor will be depreciated under the MACRS system using the applicable depreciation rates are 33%, 45%, 15%, and 7% respectively. Production is estimated to last for three years, and the company will exit the market before intense competition sets in and erodes profits. The market value of the processor is expected to be $100,000 after three years. Net working capital of $2,000 is required at the start, which will be recovered at the end of the project. The juice will be packaged in 20 oz. containers that sell for $3.00 each. The company expects to sell 150,000 units per year; cost of goods sold is expected to total 70% of dollar sales.

Weighted Average Cost of Capital (WACC):

Exotic Food’s common stock is currently listed at $75 per share; new preferred stock sells for $80 per share and pays a dividend of $5.00. Last year, the company paid dividends of $2.00 per share for common stock, which is expected to grow at a constant rate of 10%. The local bank is willing to finance the project at 10.5% annual interest. The company’s marginal tax rate is 35%, and the optimum target capital structure is:

Your main task is to compute and evaluate the cash flows using capital budgeting techniques, analyze the results, and present your recommendations whether the company should take on the project.

QUESTIONS

To help in the analysis, answer all the following questions. Present the analysis in one Excel file with the data, computations, formulas, and solutions. It is preferred that the Excel file be embedded inside the WORD document (question 8).

1. What is the total investment amount at the start of the project (i.e., year zero cash flow)?
2. What is the depreciation amount for each year?
   • Create a depreciation schedule
3. What is the after-tax salvage value of the equipment?
4. What is the projected net income and Operating Cash Flows (OCF) for the three years?
   • Complete an income statement for each year.
5. What are the Free Cash Flows (FCF) generated from the project?
   • Create a projected cash flow schedule
6. What is the Weighted Average Cost of Capital (WACC)?
   • Compute the after-tax cost of debt
   • Compute the cost of common equity
   • Compute the cost of preferred stock
   • Compute the Weighted Average Cost of Capital (WACC)
7. Using a WACC of 15%, apply four capital budgeting techniques to evaluate the project, assuming the Free Cash Flows are as follows:

   Years	Free Cash Flows
   0	($252,000.00)
   1	$118,625.00
   2	$127,125.00
   3	$181,000.00

   
   The four techniques are NPV, IRR, MIRR, and discounted Payback. Assume the reinvestment rate to be 8% for the MIRR. Also, assume that the business will only accept projects with a payback period of two and half years or less.
8. Which of the four techniques should be selected and why?

You are an RD running a weight-loss and healthy eating program at a local endocrinologist’s office. This three-month program consists of once-weekly private, one-on-one nutrition counseling sessions with you, as well as once-weekly group meetings where you lead a discussion on a topic relevant to healthy eating and physical activity. It costs $600 to enroll in the three-month program. Currently, you have 20 clients enrolled, all direct referrals from the endocrinologist’s practice. The program is designed to appeal to both men and women, ages 18 and up.

The endocrinologist would like to grow this wellness program and expand it beyond her own client pool. Not only do you have to market the program to attract new clients but also create marketing tools that will keep current clients interested and possibly spur them to re-enroll beyond three months if needed. This takes time, and you are the only RD managing the program, plus counseling clients.

You need to consider your competition. This includes not only other dietitians in your area but weight-loss companies that are well known and cheaper, such as Weight Watchers. One advantage is that your program may be covered by some insurance plans, mostly for cases where clients have diabetes.

Another consideration is that you have little experience with marketing. You do know how powerful marketing can be to help build the practice. You have a limited budget that will not allow for advertising on TV, radio, or in local newspapers. In addition, the endocrinologist does not use or understand social media such as Facebook. She feels the program can grow successfully by word-of-mouth alone and that marketing may not be necessary. You must figure out a way to create buzz about the program to get potential clients in the door within budgetary constraints.

1. What are your challenges in marketing this weight-loss program? What are some things you may be unsure of in this marketing process?

2. Using information from your text about brand image, identify a “brand image” for your weight-loss program. Be creative in coming up with a name for the program, potential slogan, brand logo, and other branding ideas.

3. What marketing tools will you use? Consult your text and the three websites listed at the beginning of this case study. Also use any of your own knowledge on topics such as social media (e.g., Facebook, Twitter). List each marketing tool and your rationale for choosing that particular tool. Be sure to include a mix of traditional marketing tools and new ones such as social media. For each tool:

• Explain what the tool is and why you are using it.
• What audience do you plan to target with this tool?
• Draft an example of the actual tool, or an outline of what content will be included in the tool.
• How do you plan to measure the success of this tool

4.outline a timeline for rolling out your marketing plan

5. identify some tools you will use for current clients to keep them interested in the program and returning for more nutrition services as needed.

6. Describe how you will evaluate and measure the success of your program and your return on investment (ROI) for each marketing tool used in order to determine whether they are cost-effective enough to be used again. Brainstorm ideas on your own and consult Step 5 (“Evaluation”) of the Social Marketing for Nutrition and Physical Activity web course.

Once you have the dataset, please use knowledge gained in other business and/or economics classes to realize what topic and theory the data could relate and a research question that it could allow you to answer. More specifically, please put together an analysis by making sure your project report includes the following:

1. Brief statement of the research topic and problem. As you get the dataset from me, you would need to use some imagination what research problem that data could be related to. Nevertheless, please state very briefly (i.e. in one paragraph) what theory (research literature or textbooks related to business or economics) says about the research problem – e.g. is there some dilemma or controversy that your research will help to clarify.
2. Clearly worded research question that limits the research problem to researchable task. (This is a short sentence that ends with the question mark and it is suggested that you draw from theory (research literature / textbook knowledge) in one of the business studies field to word it!)
3. Please identify the type of data that you are working with – on what type of measurement scale(s) where the selected variables measured by the original data collectors. (As you work with the dataset given by me, use your educated guess).
4. Describe the data with the tools of descriptive statistics, using both numerical as well as graphical methods. In addition to reporting and commenting on the values central tendency and diagrams, please also justify the choice of method (e.g. why a particular kind of measure of central tendency was selected and the chosen graphic is appropriate to use in this context).
5. Justify the selection of the specific data analysis method of inferential statistics. Recommendation – use the decision tree (introduced in Ch. 9ff) to make the selection and justification of it. You should look up also the assumptions and comment how your data meets them but I will not penalize you if it does not meet all the criteria. Nevertheless, please make sure that you include the basic information about distribution of the variables – are they more or less normally distributed (use both numerical as well as graphical methods). It is required that you restrict the choice of data analysis method(s) to the ones introduced in the class. (In addition to the fact that we covered only the most basic / frequently used methods in class, also the spreadsheet program (Excel) which the textbook is based on and that I presented during the course, has limited set of methods available).
6. Formulate the null and research (alternative) hypothesis – similarly to point 2 it is recommended that you word them on the basis of research literature / textbook knowledge in one of the business studies field that you know);
7. Determine the test criteria:

7.1. Specify the level of significance (Type I error associated with the null hypothesis),

7.2. Determine the test statistic (the appropriate statistical test as mentioned under point 5 above),

7.3. Determine the critical values (and region(s) if applicable),

8. Calculate the value of the test statistic (obtained value).
9. Make a decision about the null and research hypothesis by comparing the obtained value to the critical value and interpret the results of the data. You can pay attention also to the p-values.
10. Sum up you research report by relating the statistical test result(s) to the research question and theory that you set to test.

Retail operations and retail inventory ‘Splash Out The Back’ began business on 1 November 2019. The business has been set up as a partnership between Mr. and Mrs. Fisher. It operates an online store, selling inflatable swimming pools to the public, for use in back yards. The business began by selling one particular model of inflatable swimming pool but will look to expand the product lines that it sells within the next year. The business is registered for GST. The following transactions occurred during November 2019:
Date Details
1 Nov Mr. and Mrs. Fisher deposited $20,000 into the business bank account ($10,000 each).
1 Nov ‘Splash Out The Back’ rented a small warehouse for the business, to store inventory that is purchased. The warehouse rent costs $330 per month (including GST). ‘Splash Out The Back’ pays the landlord $990 from the bank account, for rent for November, December, and January.
8 Nov ‘Splash Out The Back’ purchased 30 of the inflatable swimming pools on account for $88 per pool, including GST, from the pool manufacturer, Intex Pools Ltd. Intex Pools Ltd also charged a delivery fee on the invoice of $55, including GST (to deliver the swimming pools to ‘Splash Out The Back’). The invoice is due for payment on 20 November.
15 Nov ‘Splash Out The Back’ paid the invoice from Intex Pools Ltd (for purchases made on 8 November) from the business bank account.
16 Nov ‘Splash Out The Back’ sold 12 of the swimming pools via its online store, at $165 each (including GST). All of the customers paid by Paypal and the money was received in the business bank account by the end of the day. Note: ‘Splash Out The Back’ does not pay any PayPal fees when customers pay by PayPal.
20 Nov One of the customers who purchased a swimming pool on 16 November returned their swimming pool for a refund. The swimming pool was returned in an original, brand new condition (unopened). The customer paid for the freight to return the swimming pool, and ‘Splash Out The Back’ refunded the customer $165 from the business bank account.
22 Nov ‘Splash Out The Back’ purchased 40 of the inflatable swimming pools on account for $99 per pool, including GST, from the pool manufacturer, Intex Pools Ltd. Intex Pools Ltd also charged a delivery fee on the invoice of $55, including GST, to deliver the swimming pools to ‘Splash Out The Back’. The invoice is due for payment on 5 December.
23 Nov ‘Splash Out The Back’ had a 24-hour sale, and sold 34 of the swimming pools via its online store, at $143 each (including GST). All of the customers paid by Paypal and the money was received in the business bank account by the end of the day.
25 Nov ‘Splash Out The Back’ was contacted by a primary school. The primary school wanted to purchase 10 of the inflatable swimming pools for their school water fun day. ‘Splash Out The Back’ agreed to sell 10 of the swimming pools to the primary school for $154 each (including GST). The sale was made on credit terms of 2/10, n/30.
27 Nov ‘Splash Out The Back’ received the money in the business bank account from the primary school that purchased swimming pools on 25 November. The amount received was the invoiced amount, less the sales discount.
30 Nov Mrs. Fisher accidentally damaged one of the swimming pools in the warehouse, and the swimming pool needs to be written off.
30 Nov ‘Splash Out The Back’ received an invoice from Telstra (for telephone and internet used by the business), with an amount payable of $88 (including GST). The due date for payment is 16 December.
30 Nov ‘Splash Out The Back’ received an invoice from Australia Post for postage costs re. delivering swimming pools to customers. Australia Post charges $9.90 postage per swimming pool delivered (including GST). The invoice is due for payment on 20 December.
Mr & Mrs. Fisher don’t have any experience keeping inventory and accounting records. They have come to you for assistance.

Required:
i. Prepare a business report*for ‘Splash Out The Back’ to help the owners understand the different inventory accounting systems (periodic and perpetual), and costing methods (specific unit cost; first-in-first-out (FIFO); last-in-first-out (LIFO); and average cost methods). In your report, also discuss any advantages and disadvantages of these different systems and methods. Given your knowledge of the business and your knowledge of the regulatory requirements that will apply to ‘Splash Out The Back’, include a recommendation on the inventory system and costing method/s that ‘Splash Out The Back’ should consider adopting. (Word guide: 1,000 words)

ii. Prepare Excel worksheets for the swimming pools for November using the perpetual inventory system and the FIFO, LIFO, and average-cost methods. In your spreadsheets, keep track of the number of swimming pools purchased, swimming pools sold, swimming pools on hand, cost of goods sold, and gross profit made.

iii. Now assume that ‘Splash Out The Back’ has adopted the perpetual inventory system and the FIFO costing method. Prepare journal entries (including any adjusting entries) for all of the business’s transactions for November. Include dates, references, and narrations. (4.5 marks)

iv. Prepare T-accounts in an Excel spreadsheet, and post all of the above journal entries
to the T-accounts. Include dates and references for each entry. Total all of the T accounts to determine their balances at the end of November 2019. (1 mark)

v. Prepare the ‘Adjusted Trial Balance’ in an Excel spreadsheet as at 30 November 2019. Use formulas to generate all of the figures in the ‘Adjusted Trial Balance’ from the balances in the T-Accounts. (1 mark)

vi. Prepare the income statement, balance sheet, and statement of changes in equity in Excel. Use formulas to generate all of the figures in the financial statement reports from the ‘Adjusted Trial Balance’.

vii. Assume that ‘Splash Out The Back’ has a year-end date of 30 November. Prepare the closing entries as at 30 November 2019. (1.5 marks)
Please also refer to the 'Requirements' section below for additional submission and spreadsheet requirements. *Note: a business report includes:
• a coverage addressed to your desired audience; • an executive summary(refer to the note below regarding an executive summary); • a table of contents (linked to the headings in the report); • headings and subheadings clearly identify what is being discussed; • conclusion, • recommendations; and • reference list (using APA style - either the 6th or 7th edition). Note: an Executive Summary is not an introduction. An Executive Summary should be an overview of the entire report, including recommendations, and no longer than one (1) page in length. This may be the only page read by busy managers.

The word count guide does not include your:
• cover page; • executive summary; • table of contents; • tables/calculations; and • reference list (in-text citations and reference list).