Question: Xcel ATC 8-7 Spreadsheet Assignment Mastering Excel Wilkin Fruit Drink Company planned to make 400.000 containers of apple juice. It expected to use two cups

Xcel ATC 8-7 Spreadsheet Assignment Mastering Excel Wilkin Fruit Drink Company planned to make 400.000 containers of apple juice. It expected to use two cups of frozen apple concentrate to make each container of juice, thus using 800,000 cups (400,000 containers * 2 cups) of frozen concentrate. The standard price of one cup of apple concentrate is $0.25. Actually, Wilkin produced 404,900 containers of apple juice and purchased and used $20.000 cups of concentrate at $0.26 per cup. Required a. Construct a spreadsheet template that could be used to calculate price and usage variances. The template should be constructed so that it could be used for any problem in the chapter that refers to price and usage variances by changing the data in the spreadsheet. The screen capture on this page represents a template for price and usage variances. Spreadsheet Tip (1) The shaded cells can be changed according to the data in each problem. All other cells are formulas based on the numbers in the shaded cells. IF The

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Dhanraj.. Xcel ATC 8-7 Spreadsheet Assignment Mastering Excel Wilkin Fruit Drink Company planned to make 400.000 containers of apple juice. It expected to use two cups of frozen apple concentrate to...

ATC 8-7 Spreadsheet Assignment Mastering Excel Wilkin Fruit Drink Company planned to make 400,000 containers of apple juice. It expected to use two cups of frozen apple concentrate to make each...

Spreadsheet Assignment Mastering Excel Wilkin Fruit Drink Company planned to make 400,000 containers of apple juice. It expected to use two cups of frozen apple concentrate to make each container of...

Wilkin Fruit Drink Company planned to make 400,000 containers of apple juice. It expected to use two cups of frozen apple concentrate to make each container of juice, thus using 800,000 cups (400,000...

solve this with formula Wilkin Fruit Drink Company planned to make 400,000 containers of apple juice. It expected to use two cups of frozen apple concentrate to make each container of juice, thus...

Wilkin Fruit Drink Company planned to make 400,000 containers of apple juice. It expected to use two cups of frozen apple concentrate to make each container of juice, thus using 800,000 cups (...

Wilkin Fruit Drink Company planned to make 4 0 0 , 0 0 0 containers of apple juice. It expected to use two cups of frozen apple concentrate to make each container of juice, thus using 8 0 0 , 0 0 0...

Wilkin Fruit Drink Company planned to make 400,000 containers of apple juice. It expected to use two cups of frozen apple concentrate to make each container of juice, thus using 800,000 cups (...

Kevin Hall had been allocating MOH costs to his products using a single plant-wide rate of $10.00 per DL hour. His accountants were now suggesting the use of the following activity-based rates. $22...

South Seas Distributors completed the following transactions involving the purchase and operation of a delivery truck: 2011 Transaction Description May 27 Paid $35,600 for a new truck, plus $4,272 in...

A company produces a single product with the following details: Selling price $8.00 per unit Variable cost $3.00 per unit Total fixed costs $30,000 per annum Budgeted sales are 25,000 units per...

Q 1 . What is the Cooling Load of a room with the below parameters: Outdoor Temperature: 3 4 . 1 C ( W = 0 . 0 2 2 kg / kg ) ( Design Indoor Temperature: = 0 . 0 1 2 kg / kg ) ) ( Area: 2 0 4 m 2...

3. A price ceiling will result in a shortage only if the ceiling price is _______________ the equilibrium price. LO3.7 a. Less than. b. Equal to. c. Greater than. d. Faster than.

LO4.4 Explain how positive and negative externalities cause under- and overallocations of resources.

LO4.2 Explain the origin of both consumer surplus and producer surplus and explain how properly functioning markets maximize their sum, total surplus, while optimally allocating resources.