Part BSystem Implementation
Q4. Create all tables in Deakin Oracle DBMS (about nine tables including composite tables) and Populate the tables with sample data (10 records in each table is recommended). (/ 0 marks)
Q5. Alter the staff table and add new field Phone Number for staff table. Type for Phone Number should be number. (6 marks) Q6. Increase the annual salary for all managers by 5%. (6 marks) Q7. For a given actor first name, display all movies he/she played a role in. (6 marks) Q8. Display the rental history of a given customer (identified by member ID number), showing customer name, phone number, movie copy number, movie title, branch number, renting out date, and returning date. (6 marks) Q9. Create your own query. It must include a nested query. Submit the following: (6 marks) i question your query is answering the SQL query ii the mark for this question will depend on the complexity of the query. iii higher marks will be given for queries that are more complex and/or innovative. iv if you do not provide a description of what question the query is answering, you will get zero for this query.
(a) Colour Zone makes and sells industrial paints in Hinchinbrook, NSW. Eduardo Garcia, the owner is considering two alternative plans for paying his four salespersons next year (2020). Plan A is a straight commission of the equivalent of $0.40 per gallon sold. Plan B is a salary equivalent of $20 000 each plus a commission of $0.20 per gallon.
Required:
Using cost equation, determine the number of gallons all four sales persons together would have to sell for Colour Zone to pay the same total compensation under the two plans.
(b) In 2019, Colour Zone operated at full capacity of 400 000 gallons. Each sales person was paid according to Plan A. The average sale price was $10 per gallon, and the average variable cost (excluding commission) was $6 per gallon. Fixed expenses totalled $1 000 000. Garcia believes that his sales force can sell 500 000 gallons in 2020 and every year thereafter if his company can produce them. He estimates that an additional committed fixed cost of $200 000 would be required to provide another 100 000 gallons of capacity.
Required:
(i) Compute 2020 operating income on a contribution margin income statement if Colour Zone acquires the additional capacity and produces and sells 500 000 gallons. Assume that Colour Zone switches to plan B (a salary of $20 000 each and commission of $0.20 per gallon) to pay sales person.
(ii) Repeat the above requirement (i), assuming that Colour Zone continues to pay compensation according to plan A (a straight commission of $0.40 per gallon).
(iii) At production and sales volume of 500 000 gallons per year, which employee compensation plan should the company use. Why?
(b) To meet the production needs, Elizabeth Grey, the purchasing manager of Colour Zone, needs a cost function to predict purchasing department costs. She believes that the primary cost driver is the number of purchase order placed. Grey collect the following observations for the most recent six quarters of activity.
The post Problem 2 Cost behavior analysis appeared first on My Assignment Online.