Following is a database for products and sales for a wholesale power equipment company called PowerSalesco....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Following is a database for products and sales for a wholesale power equipment company called PowerSalesco. Company: PowerSales Co Database: SALES Table 1: PRODUCTS Product No ww1 ww5 xy6 bb9 PName Electric drill Skill saw Screwdriver set Fire extinguisher Table 2: ORDERS Customer Name McDowell's McDowell's McDowell's Clearmont Clearmont SuperSave SuperSave Product No ww1 xy6 bb9 bb9 ww1 ww1 ww5 Manufacturer Makita Philips Dexter Waddell Units Ordered 50 125 250 500 75 100 56 Unit price 124.95 231.95 34.95 50.00 Order Date 18/Jan/18 19/Jan/18 19/Jan/18 18/Jan/18 19/Jan/18 18/Jan/18 19/Jan/18 a) (15) From the above database, design formal reports, with appropriate headings, according to the requirements below. Each report will be on a new page and will contain some data from the above database in appropriate format. i) (10) Design the output (including layout and information details) for one (1) operational report* and one (1) managerial report*. * In designing your reports focus on the characteristics of the report and the audience you are servicing. You may make assumptions on any additional data that may provide more meaningful information - so long as you state your assumptions. 1) (20) Following is a database for products and sales for a wholesale power equipment company called PowerSalesco. Company: PowerSales Co Database: SALES Table 1: PRODUCTS Product No ww1 ww5 xy6 bb9 PName Electric drill Skill saw Screwdriver set Fire extinguisher Table 2: ORDERS Customer Name McDowell's McDowell's McDowell's Clearmont Clearmont SuperSave SuperSave Product No ww1 хуб bb9 bb9 ww1 ww1 ww5 Manufacturer Makita Philips Dexter Waddell Units Ordered 50 125 250 500 75 100 56 Unit price 124.95 231.95 34.95 50.00 Order Date 18/Jan/18 19/Jan/18 19/Jan/18 18/Jan/18 19/Jan/18 18/Jan/18 19/Jan/18 a) (15) From the above database, design formal reports, with appropriate headings, according to the requirements below. Each report will be on a new page and will contain some data from the above database in appropriate format. i) (10) Design the output (including layout and information details) for one (1) operational report* and one (1) managerial report*. * In designing your reports focus on the characteristics of the report and the audience you are servicing. You may make assumptions on any additional data that may provide more meaningful information - so long as you state your assumptions. 1| Page ii) (5) Describe (point form) each of the two types of reports in terms of how the information is used to support the decisions by each level of management. b) (5) Assume these reports (from (a) above) are used as input to an executive information system. Provide examples of the types of decisions made by this level of management. What additional insights could be derived from this information at this strategic level of reporting? Consider both hard data and soft data. Explain clearly, using examples, what the specific hard data and soft data would be and how the data would be used. Following is a database for products and sales for a wholesale power equipment company called PowerSalesco. Company: PowerSales Co Database: SALES Table 1: PRODUCTS Product No ww1 ww5 xy6 bb9 PName Electric drill Skill saw Screwdriver set Fire extinguisher Table 2: ORDERS Customer Name McDowell's McDowell's McDowell's Clearmont Clearmont SuperSave SuperSave Product No ww1 xy6 bb9 bb9 ww1 ww1 ww5 Manufacturer Makita Philips Dexter Waddell Units Ordered 50 125 250 500 75 100 56 Unit price 124.95 231.95 34.95 50.00 Order Date 18/Jan/18 19/Jan/18 19/Jan/18 18/Jan/18 19/Jan/18 18/Jan/18 19/Jan/18 a) (15) From the above database, design formal reports, with appropriate headings, according to the requirements below. Each report will be on a new page and will contain some data from the above database in appropriate format. i) (10) Design the output (including layout and information details) for one (1) operational report* and one (1) managerial report*. * In designing your reports focus on the characteristics of the report and the audience you are servicing. You may make assumptions on any additional data that may provide more meaningful information - so long as you state your assumptions. 1) (20) Following is a database for products and sales for a wholesale power equipment company called PowerSalesco. Company: PowerSales Co Database: SALES Table 1: PRODUCTS Product No ww1 ww5 xy6 bb9 PName Electric drill Skill saw Screwdriver set Fire extinguisher Table 2: ORDERS Customer Name McDowell's McDowell's McDowell's Clearmont Clearmont SuperSave SuperSave Product No ww1 хуб bb9 bb9 ww1 ww1 ww5 Manufacturer Makita Philips Dexter Waddell Units Ordered 50 125 250 500 75 100 56 Unit price 124.95 231.95 34.95 50.00 Order Date 18/Jan/18 19/Jan/18 19/Jan/18 18/Jan/18 19/Jan/18 18/Jan/18 19/Jan/18 a) (15) From the above database, design formal reports, with appropriate headings, according to the requirements below. Each report will be on a new page and will contain some data from the above database in appropriate format. i) (10) Design the output (including layout and information details) for one (1) operational report* and one (1) managerial report*. * In designing your reports focus on the characteristics of the report and the audience you are servicing. You may make assumptions on any additional data that may provide more meaningful information - so long as you state your assumptions. 1| Page ii) (5) Describe (point form) each of the two types of reports in terms of how the information is used to support the decisions by each level of management. b) (5) Assume these reports (from (a) above) are used as input to an executive information system. Provide examples of the types of decisions made by this level of management. What additional insights could be derived from this information at this strategic level of reporting? Consider both hard data and soft data. Explain clearly, using examples, what the specific hard data and soft data would be and how the data would be used.
Expert Answer:
Answer rating: 100% (QA)
Operational Report Daily Sales Summary Date 20231114 Report Daily Sales Summary Company PowerSalesCo Purpose To provide a summary of daily sales for all products by customer Audience Operations manage... View the full answer
Related Book For
Posted Date:
Students also viewed these computer engineering questions
-
On July 1, 2015, Seto, Inc. purchased a fire extinguisher system for $130,000 from MTI Systems. The fire extinguisher system had an estimated life of 15 years and residual value of $2,800. Seto paid...
-
A customer intended to order 100 units of product Z96014 but incorrectly ordered product Z96015, which is not an actual product. Which of the following controls most likely would detect this error?...
-
1. Let X = (X, X,..., X) be a random sample from a discrete uniform distribution with support S = {1,2,...,0}, that is, with pmf f(x;0) = (1/0)1(x). (a) Show that the statistic = ((n+1)/k)X() is an...
-
Tort cases are so common that it is likely you or someone you know has been involved in a tort case. If so, share what the case was about, what the outcome was, and how you felt about the case and...
-
Illustrate and describe the effects on output and welfare if the government regulates a monopoly so that it may not charge a price above p, which lies between the unregulated monopoly price and the...
-
For each of the following research projects, list three variables for stratification of the sample. a. A nationwide study of motels and hotels is being conducted. An attempt will be made to determine...
-
Consider the following accounting principles: 1. Entity principle 2. Revenue recognition principle 3. Matching concept Define these accounting principles. Discuss how these principles relate to one...
-
The monthly and hourly wage schedule for the employees of Quincy, Inc., follows. No employees are due overtime pay. Compute the following for the last monthly pay of the year: a. The total wages of...
-
Helmer's Rockers manufactures two models, Standard and Premium. Weekly demand is estimated to be 100 units of the Standard Model and 70 units of the Premium Model. The following per unit data apply:...
-
An investor, wants to know how two portfolios are performing in the market: 7% Y (3%) 12% Probability Market portfolio 0.40 0.20 15% 0.40 Beta factor 10% 18% Portfolio X 1.30 10% 8% 4% 0.75 1 The...
-
Ford Motor Company anticipates paying a dividend of $2.30 next year and intends to increase the dividend by 3% per year in perpetuity. What is the expected price of Ford stock today? Beta Company US...
-
Determine the electric field at the location shown with the "X" in unit vector notation. The charge magnitudes are q1 = 4.3 nC and q3 = 6.7 nC, The distance is d = 0.190 m. Show a free body diagram...
-
You have purchased one call and one put option on the same underlying stock. The strike price of the call option is 195 SEK and the strike price of the put option is 205 SEK. a)What is the minimum...
-
@ Consider y defined as a function of x by the equation: Ax+By+C=0 If A, B and C are constants, show that the graph of y is a straight line. What happens when B=0? Note that we say that the locus of...
-
PepsiCo can borrow in the debt market at 8%, and it currently has a debt to equity ratio (D/E) of 50%. If the cost of equity is 12%, what is the WACC? Assume that the corporate tax rate is 25%, and...
-
Identify line and staff positions at Rutgers Recreation ("a line position holds direct responsibility within the organisational chain, whereas a staff position provides support to line personnel or...
-
What does the Override annotation do? A It instructs the compiler to ignore other methods of the same name. B It instructs the compiler to double-check the method declaration is correct. C It only...
-
Why is inventory management important for merchandising and manufacturing firms and what are the main tradeoffs for firms in managing their inventory?
-
AB plc makes two products, Alpha and Beta. The company made a 500 000 profit last year and proposes an identical plan for the coming year. The relevant data for last year are summarized in Table 1....
-
Kaminsky Ltd manufactures belts and braces. The firm is organized into five departments. These are belt-making, braces making, and three service departments (maintenance, warehousing and...
-
Milo plc has a number of chemical processing plants in the UK. At one of these plants it takes an annual input of 400000 gallons of raw material A and converts it into two liquid products, B and C....
-
Determine and Use Overhead Rate Cortez Consulting, Inc., expects the following costs and expenses during the coming year: Required a. Compute a predetermined overhead rate applied on the basis of...
-
Determine and Use Overhead Rate The following selected ledger accounts of Cameron Company are for February (the second month of its accounting year): Required a. Determine the amount of indirect...
-
Job Cost Journal Entries Holiday Manufacturing had the following inventories at December 31, 2018, the end of its fiscal year: During January 2019, the following transactions occurred: 1. Purchased...
Study smarter with the SolutionInn App