Chapter 14, Problem 14.1DA

I need help completing this assignment base on the scenario listed below using Excel  Scenario: The Redmond Management Association held its annual public relations luncheon in April Year 2. Based on the previous year’s results, the organization allocated $25,290 of its operating budget to cover the cost of the luncheon. To ensure that costs would be appropriately controlled, you, the treasurer, prepared the following budget for the Year 2 luncheon.   Using Excel showing all work and formulas to complete the following: Preparing a flexible budget. Computing the sales volume variance and the variable cost volume variances based on a comparison between the master budget and the flexible budget. Computing flexible budget variances by comparing the flexible budget with the actual results.

Answer?

Honda Corporation had beginning raw materials inventory of $34,500. During the period, the company purchased $128,000 of raw materials on account. If the ending balance in raw materials was $22,700, the amount of raw materials transferred to work in process inventory is?