Question: Wellstone Company estimates that 2012 unit sales will be 18,000 in quarter 1, 24,000 in quarter 2, and 30,000 in quarter 3, at a unit

Wellstone Company estimates that 2012 unit sales will be 18,000 in quarter 1, 24,000 in quarter 2, and 30,000 in quarter 3, at a unit selling price of $20. Management desires to have ending finished goods inventory equal to 10% of the next quarter's expected unit sales.
Instructions
Prepare a production budget by quarter for the first six months of 2012?

Step by Step Solution

★★★★★

3.31 Rating (166 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

WELLSTONE COMPANY Production Budget For the Six Months Ending June 30 2012 Qua... View full answer

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

1213-B-M-A-J-O-C(3607).docx

120 KBs Word File

Students Have Also Explored These Related Managerial Accounting Questions!

Mastery Problem: Job Order Costing Purl of Great Price Company Maria Young is the sole stockholder of Purt of Great Price Company (POGP Company), which produces high-end knitted sweaters and sweater...

Zeller Company estimates that 2012 unit sales will be 18,000 in quarter 1, 24,000 in quarter 2, and 30,000 in quarter 3, at a unit selling price of $20. Management desires to have ending finished...

Wellstone Company estimates that 2011 unit sales will be 18,000 in quarter 1, 24,000 in quarter 2, and 30,000 in quarter 3, at a unit selling price of $20. Management desires to have ending finished...

Moon Company estimates that unit sales will be 10,000 in quarter 1; 12,000 in quarter 2; 14,000 in quarter 3; and 18,000 in quarter 4. Using a sales price of $80 per unit, prepare the sales budget by...

Required- Please give the right answers and show you use formulas in your spreadsheet. The total expected cash collections for the year should be now $2085000. If you don't get the answer, find the...

This a four part question. ABC Company manufactures a single product and is in the process of creating a master budget for 2020. The 2019 year-end balance sheet information can be found on the...

Oak Creek Company is preparing its master budget for 2011. Relevant data pertaining to its sales, production, and direct materials budgets are as follows. Sales : Sales for the year are expected to...

A B D E G H H Yellow-use only cell references Blue-may type numbers here Little Annin Flagmakers Sales Budget (USD) April May June Quarter Expected 2,000 3,000 4,000 2,000 1,000 Budgeted Sales...

Only number 4 and 5. I put the answers to some parts 4. Determine cash flow and other financial effects a. Cash collection schedule b. Cash disbursement for purchases, factory overhead, and selling...

3 Fill in The Blanks A. ALISON MANUFACTURING SALES BUDGET FOR THE COMING YEAR Year 11,100 Expected Unit Sales Unit Selling Prices Budgeted Sales Quarter 1 2,000 $70,00 $140,000 Quarter 2 2,400 $70.00...

tion: SUM; Formula: Subtract, Multiply; Cell Referencing g Excel to Prepare a Production Budget PROBLEM ge Company estimates that following unit sales and desired entory level for the four quarters...

Derek decides to buy a new car. The dealership offers him a choice of paying $593.00 per month for 5 years (with the first payment due next month) or paying some $28,611.00 today. He can borrow money...

In an experiment, events A and B are mutually exclusive. If P(A)= 0.6, then the probability of B cannot be determined with the information given cannot be larger than 0.4 can be any value between 0...

bob is the building a fence around his farm house. he has 1 2 0 m of fencing to use to fence in the farm. what are the dimensions of the maximum area Bob can enclose

Psychoanalytic therapists believe it is necessary to explore in detail a client's childhood . Do you agree ? Why or why not?

69. Programming is a step-by-step process needs no keyword. 70. The intersection of cach column and row in a spreadsheet is a cell. In Excel, the mouse pointer displays as a block plus sign whenever...

Can we make waveguide from plastic?

If earphones are connected to phone what is that. (transmission line/waveguide)

19. World Series Games The USA Today headline of Seven-game series defy odds referred to a claim that seven-game World Series contests occur more often than expected by chance. Listed below are the...

Waterways uses time and material pricing when it bids on drainage projects. Budgeted data for 2016 for installation division 1 are as follows. Part 1 Waterways desires a $23 profit margin per profit...

Russo Manufacturing Company uses the following budgets: balance sheet, capital expenditures, cash, direct labour, direct materials, income statement, manufacturing overhead, production, sales, and...

Oak Creek Company is preparing its master budget for 2016. Relevant data pertaining to its sales, production, and direct materials budgets are as follows. Sales: Sales for the year are expected to...

Hello I need to find this using excel please AAA Corp. is comparing two different capital structures. Plan I would result in 12,700 shares of stock and $100,050 in debt. Plan II would result in 9800...

Consider the Finapres data from Recall that the blood pressure of babies was measured using two different methods. The question being asked is about the mean difference between the two measures taken...

People use several methods to keep track of appointments, meetings, and deadlines. Some of these are using a desk calendar, using informal notes of scrap paper, keeping them in your head, using a day...