INDIVIDUAL ASSIGNMENT
This assignment comprise of FOUR (4) questions consisting of spreadsheet, word processor, database, and slides. You may use other software aside from Ms Excel, Ms Word, Ms Access, and Ms PowerPoint. However, note that the module specifically focuses on the four mentioned software both in lecture and in labs. Each question in each section has its own software application requirements. Read all of the questions carefully to fully understand the requirements before starting the assignment. This assignment is an INDIVIDUAL Assignment.
Learning Outcomes:
In conclusion, students should be able to:
Create a professional-looking documentation with sufficient coverage.
Prepare a financial accounting spreadsheet with
…show more content…
The sales sheet(s), which should consist of the following (but not limited to):
a. Product ID, product description, selling price, and the number of on hand should be displayed exactly as in the inventory (no modification of data is allowed here)
b. Number of item sold that would automatically update the inventory’s number of item sold (access given only to the employee with the corresponding brand)
**Hint: Protect all non-modified access
**Hint: Use passwords to enable access to the employees
[5 marks]
4. The employees’ salary sheet should consist of the following (but not limited to):
a. Staff’s ID that is uniquely assigned to all employees
b. Staff’s name
c. Staff’s fix monthly salary
d. Staff’s commission
i. If the target sales revenue is less than RM1500, the commission is 5% from the selling price of the item sold ii. If the target sales revenue is equal to or greater than RM 1500, the items sold after that will be counted with a commission of 15% from the selling price.
e. Staff’s performance
i. If the target sales revenue is equal to or greater than RM 1500, the performance is “Good”. ii. If the target sales revenue is less than RM1500 but greater than RM1000, the performance is “Above average”. iii. If the target sales revenue is less than RM1000 but greater than RM500, the performance is “Satisfactory”. iv. If the target sales revenue is less than RM500, the performance is “Below average”.
[4 marks]
5. The analysis sheet
1. Gross revenue as an indicator of performance is useful but has the limitation of being an absolute measure which may not reveal market shifts relative to competition.
* Our company’s sales forecast has been based on performance from previous years along with market circumstances. We are looking at the future of the business objectively which we then can evaluate past to
b) Additional sales dollars must be produced to cover each $1.00 of incremental advertising for Rash-Away
* In 2005, the profit was approximately ($144,000 / $5,500,000) 2.6% of sales; does this number indicate whether the company is doing well or not?
Option 1: Sales on Q1, Q3 and Q4 less 30% than Q2. That’s mean the volume of Q2 going to increase 30% than other and the commission will increase 30% as well
The company ended in the last place, and we know that there are areas of opportunities. In spite of this, out of the five performance areas, our weighted average scores were above the investor expected standards for Y2015. On the other hand, we never meet the image rating score of 70, and our EPS fell
* Refer sheet “25000 Sales” for cost incurred and Gain/loss for AIFS for different scenarios and actual sales volume of 25000.
a. Test market results for the southeast regions do not indicate an impressive gain in the market (i.e. market share increased from 9% to 10% when it was expected to reach 15%, display activity was below what the team expected)
There is a new commission based on the product gross margin , but neither commission will be paid until gross exceeded 70% at the early stages of the measuring year because the people will not be optimistic in achieving the 70% cap (de-motivating factor).
In a company like Bayonne Packaging, Inc., a printer and paper converter, it is very important that performance measures such as cost, quality and delivery are in agreement with the forecasted values since this firm used to compete based on low cost, good
Q.3 Why Superior Improved Profitability during the period January 1 to June 30, 2005? How useful was the data in Exhibit 4 for the purpose of this analysis?
The author states that the performance of a company cannot be considered as good if it is not on par with its competitors. For example, the present company has a customer satisfaction rating of 73%, whereas the average company has 76% and the top company has 87% out of a hundred. These statistics prove that the even though the present company is good, it is still not on par with the top company and that it requires further improvement to hold a good market value. The support costs per call can be considered good only when compared to the best
The performance had to be forced in a bell curve like curve where high performers could be maximum of 14%; Achievers (A) min 70%; Low Achievers (L) min 7% and Unacceptable (U).
At the end of quarter 2 the Gross Profit of the company was $ 1,031,772 with the operating profit $ 118,983. The company strived to achieve the operating profit in positive numbers however it was taken into consideration that the operating profit might result in negative numbers during the initial stage. However,