Product cost flows (Excel Format)

"Of all the times this hard drive could crash, it had to be now," Marcy cried. "How can I finish the financial reports without all the information? I knew I should have backed up the disk last night before I left work." News of the disaster traveled quickly through the office, and people began to stop by her cubicle to offer their help.
John was the first to the rescue. "It might not be as bad as you think, Marcy. I have the financial reports from last month right here. According to the balance sheet, we had a total inventory of $99,000 at the end of last month. And I remember that the Finished Goods Inventory was 1/3 of that amount."
"I just finished the inventory counts last night," Peter chimed in from across the hall. "According to my tally sheets, we finished this month with $80,000 in Direct Materials Inventory, $52,000 in Work in Process Inventory, and $25,000 in Finished Goods Inventory. This was a 100% increase from the balances in Direct Materials Inventory and Work in Process Inventory at the end of last month. I bet with a little more investigative work, we can get all the numbers you need to complete the reports."
Sally called from Payroll to tell Marcy that the company had paid a total of $36,000 for direct labor during the month. Juan, the billing supervisor, e-mailed Marcy that the company had sent out invoices to customers totaling $291,000.
Marcy knew that the overhead rate was 200% of direct labor costs. She also knew that the company priced its product using a 50% markup on the cost of goods sold. Armed with all this information, she sat down to reconstruct the inventory accounts.

(a) Using the information available to Marcy, prepare T-accounts to reflect the inventory cost flows for the month.
(b)Prepare a schedule of cost of goods manufactured in good form.