QUESTION 1

Feast E-Mart Sdn. Bhd. is an online grocery store that offers home delivery of groceries to customers around Changlun, Jitra, and Alor Setar. Feast E-Mart purchases their supplies of grocery products from suppliers in Kedah, Perlis and Penang. The shop is located at the new Kedah SME Industrial area beside the Kedah River. Installation of surveillance camera at entrance area is expected to be completed in two months. Due to a limited building space, a warehouse is built in a separate area behind the store. This warehouse consists of two large room with one main entrance. One room is rented by Feast E-mart, while another room is rented by other business selling electrical parts. Each room has a modern touch surrounded with glass windows and installed with glass door and air conditioner. There are two security guards hired to scout the area. Each of them work individually on a 12-hour shift basis.

The following paragraphs present the purchasing procedures of Feast E-Mart. Currently, the business adopts basic technology in its purchasing system with an independent system maintain in each department.

Inventory Control Procedures

Inventory status are retrieved from the Sales Management System. The inventory records include a quantity on hand and a desired quantity on hand for all grocery types in the inventory database. Each day, the inventory control clerk monitors the balance of inventories in the database, showing those items that have reached their reorder points. Then, the clerk prints a purchase requisition (PR) from the system and approves the reordering of inventory by signing the PR. Then, the clerk forwards the approved PR to the Purchasing Department.

Purchasing Procedures

Upon receiving the approved PR, the purchasing clerk keys in purchasing data to prepare purchase order (PO), selects a supplier from the registered supplier file in the purchase database, update the PO file and creates a purchase order on the purchasing system. Once the purchase order is saved, the completed purchase order is printed in four copies. PO1 is sent to the supplier, PO2 is sent to the Inventory Control Department, PO3 (blind copy) is sent to the Receiving Department and PO4 is sent to the Accounts Payable Department. The approved PR is filed. In certain situation, if the chosen supplier is unable to fulfill the order, urgent order request will be made to any other supplier available in Alor Setar area. No purchase requisition is issued in this situation.

Receiving Procedures

When the inventory arrives at the Receiving Department from the supplier, the receiving employees are expected to check and count the inventory, and compares the actual quantity to the quantity stated in the attached packing slip and PO3. This process is, however, unmonitored and based on trust to the employees. Then, the employee keys in the PO number and records the actual quantity of inventory received in the receiving database to create a receiving report (RR). Four copies of RR are printed from the database. The receiving clerk keeps PO3 and PS in a file. RR1 is sent to the Inventory Control department to update the inventory balances in the inventory database. RR1 is then filed in the Inventory Control Department. RR2 is sent to the Purchasing Department to be filed. RR3 is sent together with the inventory to the Warehouse. Finally, RR4 is sent to the Accounts Payable Department.

Accounts Payable Procedures

Earlier on, Accounts Payable Department received PO4 and RR4. Both documents are filed temporarily. When invoice arrived from the supplier, Accounts Payable clerk performs three-way match of PO4, RR4 and Supplier Invoice. After verifying the accuracy of invoice, the clerk keys in the invoice data into the Accounts Payable (AP) database to update purchase journal and AP subsidiary ledger. The three documents of PO4, RR4 and Supplier Invoice are filed. A journal voucher is printed and sent to the General Ledger Department.

REQUIRED:

1. Prepare the following diagrams to represent the purchasing process at Feast E-Mart Sdn. Bhd.

1. A context diagram.

2. A logical data flow diagram.

(14.5 Marks)

3. A system flowchart.

(32.5 Marks)

QUESTION 1

Feast E-Mart Sdn. Bhd. is an online grocery store that offers home delivery of groceries to customers around Changlun, Jitra, and Alor Setar. Feast E-Mart purchases their supplies of grocery products from suppliers in Kedah, Perlis and Penang. The shop is located at the new Kedah SME Industrial area beside the Kedah River. Installation of surveillance camera at entrance area is expected to be completed in two months. Due to a limited building space, a warehouse is built in a separate area behind the store. This warehouse consists of two large room with one main entrance. One room is rented by Feast E-mart, while another room is rented by other business selling electrical parts. Each room has a modern touch surrounded with glass windows and installed with glass door and air conditioner. There are two security guards hired to scout the area. Each of them work individually on a 12-hour shift basis.

The following paragraphs present the purchasing procedures of Feast E-Mart. Currently, the business adopts basic technology in its purchasing system with an independent system maintain in each department.

Inventory Control Procedures

Inventory status are retrieved from the Sales Management System. The inventory records include a quantity on hand and a desired quantity on hand for all grocery types in the inventory database. Each day, the inventory control clerk monitors the balance of inventories in the database, showing those items that have reached their reorder points. Then, the clerk prints a purchase requisition (PR) from the system and approves the reordering of inventory by signing the PR. Then, the clerk forwards the approved PR to the Purchasing Department.

Purchasing Procedures

Upon receiving the approved PR, the purchasing clerk keys in purchasing data to prepare purchase order (PO), selects a supplier from the registered supplier file in the purchase database, update the PO file and creates a purchase order on the purchasing system. Once the purchase order is saved, the completed purchase order is printed in four copies. PO1 is sent to the supplier, PO2 is sent to the Inventory Control Department, PO3 (blind copy) is sent to the Receiving Department and PO4 is sent to the Accounts Payable Department. The approved PR is filed. In certain situation, if the chosen supplier is unable to fulfill the order, urgent order request will be made to any other supplier available in Alor Setar area. No purchase requisition is issued in this situation.

Receiving Procedures

When the inventory arrives at the Receiving Department from the supplier, the receiving employees are expected to check and count the inventory, and compares the actual quantity to the quantity stated in the attached packing slip and PO3. This process is, however, unmonitored and based on trust to the employees. Then, the employee keys in the PO number and records the actual quantity of inventory received in the receiving database to create a receiving report (RR). Four copies of RR are printed from the database. The receiving clerk keeps PO3 and PS in a file. RR1 is sent to the Inventory Control department to update the inventory balances in the inventory database. RR1 is then filed in the Inventory Control Department. RR2 is sent to the Purchasing Department to be filed. RR3 is sent together with the inventory to the Warehouse. Finally, RR4 is sent to the Accounts Payable Department.

Accounts Payable Procedures

Earlier on, Accounts Payable Department received PO4 and RR4. Both documents are filed temporarily. When invoice arrived from the supplier, Accounts Payable clerk performs three-way match of PO4, RR4 and Supplier Invoice. After verifying the accuracy of invoice, the clerk keys in the invoice data into the Accounts Payable (AP) database to update purchase journal and AP subsidiary ledger. The three documents of PO4, RR4 and Supplier Invoice are filed. A journal voucher is printed and sent to the General Ledger Department.

REQUIRED:

1. Prepare the following diagrams to represent the purchasing process at Feast E-Mart Sdn. Bhd.

1. A context diagram.

2. A logical data flow diagram.

(14.5 Marks)

3. A system flowchart.

Energy and Waste

Do you believe that the government should establish a national energy policy? If so, how would you construct this policy? Would you emphasis non-renewable energy (oil, natural gas, coal) or renewable energy (solar, hydro, thermal)? If not, how would you address our current energy issues? Again, would you emphasis non-renewable energy (oil, natural gas, coal) or renewable energy (solar, hydro, geothermal)?

Your paper should be 2-3 pages in length and all citations must use APA formatting.

On June 30, 2018, Plaster, Inc., paid $996,000 for 80 percent of Stucco Company's outstanding stock. Plaster assessed the acquisition-date fair value of the 20 percent noncontrolling interest at $249,000. At acquisition date, Stucco reported the following book values for its assets and liabilities:

On June 30, Plaster allocated the excess acquisition-date fair value over book value to Stucco's assets as follows:

At the end of 2018, the following comparative (2017 and 2018) balance sheets and consolidated income statement were available:

Additional Information for 2018

On December 1, Stucco paid a $48,000 dividend. During the year, Plaster paid $180,000 in dividends.

During the year, Plaster issued $938,400 in long-term debt at par.

Plaster reported no asset purchases or dispositions other than the acquisition of Stucco.

Prepare a 2018 consolidated statement of cash flows for Plaster and Stucco. Use the indirect method of reporting cash flows from operating activities. (Negative amounts and amounts to be deducted should be indicated by a minus sign.)

On June 30, 2018, Plaster, Inc., paid $868,000 for 80 percent of Stucco Company's outstanding stock. Plaster assessed the acquisition-date fair value of the 20 percent noncontrolling interest at $217,000. At acquisition date, Stucco reported the following book values for its assets and liabilities: Cash $ 56,800 Accounts receivable 120,400 Inventory 192,600 Land 61,800 Buildings 166,300 Equipment 284,900 Accounts payable (33,200 ) On June 30, Plaster allocated the excess acquisition-date fair value over book value to Stucco's assets as follows: Equipment (3-year remaining life) $ 71,000 Database (10-year remaining life) 164,400 At the end of 2018, the following comparative (2017 and 2018) balance sheets and consolidated income statement were available: Plaster, Inc. December 31, 2017 Consolidated December 31, 2018 Cash $ 40,200 $ 227,000 Accounts receivable (net) 338,300 453,700 Inventory 388,000 672,800 Land 280,500 342,300 Buildings (net) 229,000 346,800 Equipment (net) 1,682,500 1,909,900 Database 0 156,180 Total assets $ 2,958,500 $ 4,108,680 Accounts payable $ 75,000 $ 100,300 Long-term liabilities 375,000 1,089,620 Common stock 1,687,500 1,687,500 Noncontrolling interest 0 239,500 Retained earnings 821,000 991,760 Total liabilities and equities $ 2,958,500 $ 4,108,680 PLASTER, INC., AND SUBSIDIARY STUCCO COMPANY Consolidated Income Statement For the Year Ended December 31, 2018 Revenues $ 1,140,200 Cost of goods sold $ 690,600 Depreciation 175,400 Database amortization 8,220 Interest and other expenses 9,200 883,420 Consolidated net income $ 256,780 Additional Information for 2018 On December 1, Stucco paid a $49,600 dividend. During the year, Plaster paid $52,000 in dividends. During the year, Plaster issued $714,620 in long-term debt at par. Plaster reported no asset purchases or dispositions other than the acquisition of Stucco. Prepare a 2018 consolidated statement of cash flows for Plaster and Stucco. Use the indirect method of reporting cash flows from operating activities. (Negative amounts and amounts to be deducted should be

indicated by a minus sign.)

On June 30, 2018, Plaster, Inc., paid $812,000 for 80 percent of Stucco Company's outstanding stock. Plaster assessed the acquisition-date fair value of the 20 percent noncontrolling interest at $203,000. At acquisition date, Stucco reported the following book values for its assets and liabilities:

On June 30, Plaster allocated the excess acquisition-date fair value over book value to Stucco's assets as follows:

At the end of 2018, the following comparative (2017 and 2018) balance sheets and consolidated income statement were available:

Additional Information for 2018

• On December 1, Stucco paid a $44,000 dividend. During the year, Plaster paid $84,000 in dividends.
• During the year, Plaster issued $705,600 in long-term debt at par.
• Plaster reported no asset purchases or dispositions other than the acquisition of Stucco.

Prepare a 2018 consolidated statement of cash flows for Plaster and Stucco. Use the indirect method of reporting cash flows from operating activities. (Negative amounts and amounts to be deducted should be indicated by a minus sign.)

On June 30, 2018, Plaster, Inc., paid $972,000 for 80 percent of Stucco Company's outstanding stock. Plaster assessed the acquisition-date fair value of the 20 percent noncontrolling interest at $243,000. At acquisition date, Stucco reported the following book values for its assets and liabilities:

On June 30, Plaster allocated the excess acquisition-date fair value over book value to Stucco's assets as follows:

At the end of 2018, the following comparative (2017 and 2018) balance sheets and consolidated income statement were available:

Additional Information for 2018

• On December 1, Stucco paid a $45,600 dividend. During the year, Plaster paid $156,000 in dividends.
• During the year, Plaster issued $896,820 in long-term debt at par.
• Plaster reported no asset purchases or dispositions other than the acquisition of Stucco.

Prepare a 2018 consolidated statement of cash flows for Plaster and Stucco. Use the indirect method of reporting cash flows from operating activities. (Negative amounts and amounts to be deducted should be indicated by a minus sign.)

Data modeling is a key component to creating a database. There are all different aspects of data modeling, with concerns from various things to the methodology of modeling, to software, to interfaces used between each model.

Paper: Write a 3 page paper (at model 1.2 spacing, 12 pt font, 1 inch margins with at most one half of the paper including a figure, citations not included) on some aspect of data modeling in industry. You must use reliable academic and industry resources. You must have at least one resource that connects your topic to industry. Write up should not exceed 4 pages, excluding citations. Example topics include:

• Data modeling challenges in transportation industry (logistics)
• Data modelling notations or techniques other than the ER or relational model (Bachman diagrams, Barker's notation, Chen's notation, Data Vault Modeling, Extended Backus–Naur form, IDEF1X, Object-relational mapping, Object-Role Modeling, Relational Model, Relational Model/Tasmania)
• Data modelling case study for a specific company.
• Suggestions for other topics from students will also be taken.

Problem 1: For the following linear programming problem: ???????? ? = 40?1 + 50?2

Subject to constraints:

3?1 − 6?2 ≥ 30

?1 – 15 ≤ 3?2 2

?1 + 3 ?2 = 24

?1, ?2 ≥ 0

1- Find the optimal solution using graphical solution corner points method or iso profit line method. Please, show the values for state variable, decisions variables, and slack and surplus variables

2- Determine the value for basic solution and non-basic solution, binding constraints and nonbinding constrains, and if there are any redundant constraints

3- Identify if there is any special case solution and state it.

solve using linear programming graphical solution

research methods for the behavioral sciences 5th edition pdf Chapter 1

1. Name one non-scientific way of knowing and a problem associated with it and then describe the empirical method of gaining knowledge and why it is better.

2. Describe the conditions under which a scientist would typically use the inductive method and when they would be more likely to use the deductive method of reasoning.