Question: Show how to do in excel with calculations. Looking for units in beginning inventory Partial data from the question - Total sales $ 215,000 $

Show how to do in excel with calculations. Looking for units

Show how to do in excel with calculations. Looking for units in beginning inventory

Partial data from the question - Total sales $ 215,000 $ Variable costs per unit Direct materials Direct labour Manufacturing overhead Selling and administration 25 30 5 6 Fixed costs (total) Manufacturing overhead Selling and administration 6,000 8,000 Units in beginning inventory Sales Units in ending inventory - units 1,400 units 200 units Your

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!

Oak Street Clinic, a not-for-profit, began 2015 with the following account balances on January 1: $ 70,000 245,000 18,000 24,000 1,500,000 300,000 21,000 Cash Accounts receivable Allowance for...

2. Keyser Corporation, which has only one product, has provided the following data concerning its most recent month of operations: Selling price $ 145 Units in beginning inventory Units produced...

A s oration, which has only one product, has provided the following data concerning its most recent month of operations: Selling price $ 141 Units in beginning inventory Units produced Units sold...

Waterloo Storage Products makes a four-drawer plastic storage cabinet on casters meant for use in garages and workshops. Each cabinet sells for $35. Data for last year's operations follow: Units in...

Waterloo Storage Products makes a four-drawer plastic storage cabinet on casters meant for use in garages and workshops. Each cabinet sells for $54. Data for last year's operations follow: Units in...

Maher Corporation, which has only one product, has provided the following data concerning its most recent month of operations: Selling price $ 191 Units in beginning inventory Units produced Units...

Rovinsky Corporation, a company that produces and sells a single product, has provided its contribution format income statement for November. Sales (6, 400 units) $428, 800 Variable expenses 300, 800...

lChuck Wagon Grills, Incorporated, makes a single prod ucta handmade specialty barbecue grill that it sells for $210. Data for last year's operations follow: Units in beginning inventory 6 Units...

PO AccessUH X Question 1 - HW Chapter 7 - Cor x + X > C D...

QUESTION ONE: Absorption and Variable Costing: Prepare and Reconcile Variable costing Statements Audiophonics Limited manufactures and sells high-quality and durable ear buds for use with personal...

Course Title: Cost Accounting. Answer all questions. Question 1 High Country, Inc., produces and sells many recreational products. The company has just opened a new plant to produce a folding camp...

Complete Case 7.3 Trans LAN Project in Larson and Gray by responding to questions 1, 2, and 3. Combine items 1 and 2 into a single Risk Assessment Form (see Figure 7.6 in Larson and Gray) and use...

Why is it difficult for a firm with weaker cash flows to mimic a dividend increase undertaken by a firm with stronger cash flows?

Classify the following costs according to the cost hierarchy: ( $ points ) a . Cost of designing molds for a new product. b . Cost of training new production workers to assemble multiple products. c...

To be adequately capitalized, what are the banks CET1, Tier I, and total riskbased capital requirements under Basel III?

Assume that an investor buys 100 shares of stock at $50 per share, putting up a 60% margin. If the stock rises to $60 per share, what is the investor's new margin position?

The following data pertains to the operations of Knight Corporation for 2012: The controller is trying to decide which method of accounting for bad debts to use. The company is attempting to maximize...

Malcolm is a retail company specializing in men's hats. Its budget director prepared the list of expected operating expenses that follows. All items are paid when incurred except sales commissions...

Humboldt, Inc. sells fireworks. The company's marketing director developed the following cost of goods sold budget for April, May, June, and July. Humboldt had a beginning inventory balance of $1,800...

Provide a full outline of Amazon's contingency plan with the implementation of brick and mortar stores, thus becoming an Omni-Channel retailer.

Identify who may be responsible for performance appraisal.

List the problems that have been associated with performance appraisal.

Explain the performance appraisal period.