HI, there I need to do the following accounting problem in excel. Thank Problem 2: A gift shop in a tourist center is open on weekends (Friday, Saturday, and Sunday). The owner-manager hopes to improve scheduling of part-time employees by determining seasonal relatives for each of these days. Data on recent activity at the store (sales transactions per day) have been tabulated and are shown in the table below. 1 2 3 4 5 6 Friday 149 154 152 150 159 155 Saturday 250 255 260 268 273 269 Sunday 166 162 171 173 176 182 a) Develop seasonal relatives for the shop. (Sat. = 1.34) These are the seasonal percentages or seasonal indexes. They are expressed as a percentage of the average, or trend, which is used to incorporate seasonality that deviates from the average trend line. b) Use a naïve trend approach to predict sales transactions for the gift shop in this problem for the following week. (Fri. = 151).
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Excel 2000,2003