Create a handwritten/manual solution AND a spreadsheet solution to the following problem. Follow the template provided. Play the Job Cost podcasts from Interact Resources and work through the example problem in those podcasts. The example problem in the podcasts is similar to the Obese problem. Create a spreadsheet solution showing the row and column headings and the formula view. Your report section should be completely formula driven. Scan or use your phone to copy and paste an image of your handwritten attempt into your assignment. If using a smart phone, consider using a free scanning app such as Camscanner, Office Lens or Google Drive or search for an app. Let us know which app you chose.

Design your spreadsheet to meet the assignment requirements. In particular, check the spreadsheet requirements and the Spreadsheet Advice PDF.

Management accounting and history. Taking the Roman Coliseum as an example, describe how modern cost management accounting could be applied to a current attempt to recreate this structure. Be creative in your discussion (about 200 - 300 words). Add images to your answer.

G H M N O 1Reconstructing accounts DATA INPUT Ledger balances: Materials Control 31/8X7 Work-in-Process 118/X7 Finished Goods 1/8/X7 Accounts Payable 1/8/X7 30,000 9,700 12,780 5,678 10 12 14 Overhead is allocated by using a predetermined rate that is set at the beginning of each year by forecasting the year's overhead and using forecast direct labour hours as a cost driver All factory workers receive the same rate of pay An interview with the factory foreman revealed the following additional information: $1,900 1 Accounts Payable are for direct materials only. The balance on 31 August was 2 Payments for Accounts Payable made during August were 3 A stocktake after O. Bese's autopsy revealed only one unfinished job in the factory 4 Source documents showed that the one unfinished job had direct labour 5 The direct labour hours in the unfinished job was 6 The direct material in the unfinished job was 7 The finished goods inventory as at 31 August was 8 The budget for 20x7 called for total direct labour hours of 9 Budgeted factory overhead is 17 $8,700 $2,400 $9,000 20 300 hours 23 24 25 26 10 Jobs sold during August realised 27 11 Direct labour hours worked during August totalled 28 12 Finished jobs are priced at a percentage mark-up on manufacturing cost 29 30 31 32 $18,900 3,000 hours $24,000 $88,000 3,700 hours 60% Required Given this incomplete information, complete the template below and calculate the beginning balance of the Direct Materials Control account. If necessary, round to whole dollars G H M N O 1Reconstructing accounts DATA INPUT Ledger balances: Materials Control 31/8X7 Work-in-Process 118/X7 Finished Goods 1/8/X7 Accounts Payable 1/8/X7 30,000 9,700 12,780 5,678 10 12 14 Overhead is allocated by using a predetermined rate that is set at the beginning of each year by forecasting the year's overhead and using forecast direct labour hours as a cost driver All factory workers receive the same rate of pay An interview with the factory foreman revealed the following additional information: $1,900 1 Accounts Payable are for direct materials only. The balance on 31 August was 2 Payments for Accounts Payable made during August were 3 A stocktake after O. Bese's autopsy revealed only one unfinished job in the factory 4 Source documents showed that the one unfinished job had direct labour 5 The direct labour hours in the unfinished job was 6 The direct material in the unfinished job was 7 The finished goods inventory as at 31 August was 8 The budget for 20x7 called for total direct labour hours of 9 Budgeted factory overhead is 17 $8,700 $2,400 $9,000 20 300 hours 23 24 25 26 10 Jobs sold during August realised 27 11 Direct labour hours worked during August totalled 28 12 Finished jobs are priced at a percentage mark-up on manufacturing cost 29 30 31 32 $18,900 3,000 hours $24,000 $88,000 3,700 hours 60% Required Given this incomplete information, complete the template below and calculate the beginning balance of the Direct Materials Control account. If necessary, round to whole dollars