please show all work and complete PROFIT VARIANCE worksheet with favoriable and unfavoriable.

second attempt as some spreadsheets have been incomplete or cant see the full spreadsheet with work

Thanks

Osage, Inc., manufactures and sells lamps. The company produces only when it receives orders and therefore, has no inventories. The following information is available for the current month Actual (based on Master Budget (based actual orders for on budgeted orders 461,000 units) for 502,000 units) Sales revenue $4,979,899 $5,020,000 Less Variable costs Materials 1,495,000 1,506,000 Direct labor 287,000 351,400 Variable overhead 675,500 652,600 Variable marketing and administrative 490,000 502,000 Total variable costs $2,947,500 $3,012,000 Contribution margin $2,031,500 $2,008,000 Less Fixed costs Manufacturing overhead 991,200 961, 100 Marketing 299,000 299,000 Administrative 215,000 181, 100 Total fixed costs $1,585,000 $1,441,200 Operating profits $ 526,500 $ 566,300 Required: Prepare a profit variance analysis for Osage, Inc. (Do not round intermediate calculations. Indicate the effect of each variance by selecting "F" for favorable, or "U" for unfavorable. If there is no effect, do not select either option.) OSAGE INC Profit Varlance Analysis Manufacturing Marketing and Administrative Variances Varances Actual Sales Price Variance Flerable Budget Sales Activity Variance $ 461,000 $ (4,559,000) Master Hidget $ 4979,000 $ 4518,000 $ 5,020,000 F Sales revenue Variable costs Materials Direct labor Variable overhead Variable marketing and administrative Total variable costs Contribution margin Ebed costs Manufacturing overhead Marketing Administrative Totalfced costs Operating profits 1.495,000 287,000 675,500 490 000 $ 2,947,500 $ 2,031,500 1,500,000 351,400 652,600 502,000 5 3,012,000 5 2,000,000 F $ $ 461,000 991,000 299,000 215,000 $ 1505,000 $ 526,500 961,100 299,000 161,100 $ 1,441 200 5 566 800 5 $ 011 461.000