80.2K

Verified Solution

Link Copied!

A. Use Microsoft Excel to construct a Transactions Journal.Enter Transactions a tok in the Transactions Journal. Construct the Balance Sheet and Income Statement, shown in the chapter. Create links between the Transactions Journal and the financial statements to carry forward the accounting figures. B. Analyze the financial statements displayed by calculating the Current Ratio, Working Capital, Solvency, and Profitability. Is the business liquid, solvent, and profitable? A. Put together an Excel worksheet with solver to determine the schedule of feed supplement shipments from warehouses to livestock operations which minimizes shipment costs while meeting the delivery demands of the livestock operations and staying within the capacities of the warehouses. Warehouse A has capacity to store and handle 900 units of feed supplement per time period, warehouse B - 500 units, and warehouse C - 400 units. Livestock operation 1 requires 300 units of feed supplement per time period, operation 2 - 400 units, operation 3 - 200 units, operation 4 - 350 units, operation 5 - 450 units, and operation 6 - 100 units. The costs of transporting one unit of feed supplement from each warehouse to each livestock operation are listed as follows: A1 (warehouse A to livestock operation 1) A1 1.60, A2 1.80, A3 1.10, A4 1.50, A5 1.70, A6 1.00, B1 1.40, B2 1.20, B3 1.30, B4 1.10, B5 0.90, B6 0.80, C1 1.30, C2 1.50, C3 1.70, C4 1.80, C5 1.90, C6 2.00. 2. Answer the In-chapter questions in Chapter 8 Accounting. Take a screen shot of your answers and paste them in front of the exercise answers for Chapter 8. (1%) Answer the following Accounting exercise questions. (1.5%) A. Use Microsoft Excel to construct a Transactions Journal.Enter Transactions a tok in the Transactions Journal. Construct the Balance Sheet and Income Statement, shown in the chapter. Create links between the Transactions Journal and the financial statements to carry forward the accounting figures. B. Analyze the financial statements displayed by calculating the Current Ratio, Working Capital, Solvency, and Profitability. Is the business liquid, solvent, and profitable? 3.C Ch. 9 Human Resources Exercise A. Use Microsoft Excel to construct a Transactions Journal.Enter Transactions a tok in the Transactions Journal. Construct the Balance Sheet and Income Statement, shown in the chapter. Create links between the Transactions Journal and the financial statements to carry forward the accounting figures. B. Analyze the financial statements displayed by calculating the Current Ratio, Working Capital, Solvency, and Profitability. Is the business liquid, solvent, and profitable? A. Put together an Excel worksheet with solver to determine the schedule of feed supplement shipments from warehouses to livestock operations which minimizes shipment costs while meeting the delivery demands of the livestock operations and staying within the capacities of the warehouses. Warehouse A has capacity to store and handle 900 units of feed supplement per time period, warehouse B - 500 units, and warehouse C - 400 units. Livestock operation 1 requires 300 units of feed supplement per time period, operation 2 - 400 units, operation 3 - 200 units, operation 4 - 350 units, operation 5 - 450 units, and operation 6 - 100 units. The costs of transporting one unit of feed supplement from each warehouse to each livestock operation are listed as follows: A1 (warehouse A to livestock operation 1) A1 1.60, A2 1.80, A3 1.10, A4 1.50, A5 1.70, A6 1.00, B1 1.40, B2 1.20, B3 1.30, B4 1.10, B5 0.90, B6 0.80, C1 1.30, C2 1.50, C3 1.70, C4 1.80, C5 1.90, C6 2.00. 2. Answer the In-chapter questions in Chapter 8 Accounting. Take a screen shot of your answers and paste them in front of the exercise answers for Chapter 8. (1%) Answer the following Accounting exercise questions. (1.5%) A. Use Microsoft Excel to construct a Transactions Journal.Enter Transactions a tok in the Transactions Journal. Construct the Balance Sheet and Income Statement, shown in the chapter. Create links between the Transactions Journal and the financial statements to carry forward the accounting figures. B. Analyze the financial statements displayed by calculating the Current Ratio, Working Capital, Solvency, and Profitability. Is the business liquid, solvent, and profitable? 3.C Ch. 9 Human Resources Exercise

Answer & Explanation Solved by verified expert

See Answer