Question Details

[answered] ACC 207 MDE Manufacturing Budget: Bird Feeder I. Sales and


Hi Akansha,

Could you help me with the following assignments?

For Milestone One, you will use the MDE Manufacturing Budget (Table I) to analyze costs, contribution margin, and break even point for the bird feeder division of the company. In Tab 1 of your Student Workbook, classify costs as either product or period costs. Briefly explain the difference between the types of costs. Then,analyze the actual costs and, using Tab 2 of your Student Workbook, complete a cost-volume-profit analysis to determine how many bird feeders must be sold at the current cost and sales price level to earn a $10,000 profit and how much the sales price would have to increase to earn a $10,000 profit at the same cost and sales volume level. Submit the Student Workbook with Tabs 1 and 2 completed with your cost calculations and a 1?2 page Word document that explains the implications of your findings and addresses all of the critical elements in Section I.Specifically, the following critical elements must be addressed:I. ?

Costs

Classify all product and period costs appropriately.b) Compute a cost-volume-profit analysis. What are the implications of this analysis?c) Compute contribution margin per unit and contribution margin ratio.d) Determine the break even quantity and the break even revenue accurately.e) Determine if the company is breaking even. What are cost-volume-profit analysis implications on short-term planning?Guidelines for Submission: Your paper must be submitted using the Student Workbook to present your calculations and a 1?2 page Microsoft Word document with double spacing, 12-point Times New Roman font, and one-inch margins to explain your findings.

For Milestone Two, you will analyze the budget and actual costs using the MDE Manufacturing Budget (Tables I, II, III, IV). Determine where variances occurred and why. Submit the Student Workbook with Tabs 3 and 4 completed with your budgets/variances and a 1?2 page Word document that discusses the implications of your findings on MDE?s financial considerations. Explain which aspects of MDE?s budgeting process are in need of improvement and justify your response using your calculations. Address all critical elements listed below in Section II. Use Tabs 5 and 6 of the Student Workbook for your budget and variance calculations. Specifically, the following critical elements must be addressed:II. Prepare and Perform

a. What are your fixed costs? Segregate them in the budget model. b) Determine how variable costs change as activity measures change. How can this information be applied? c) Create the budget model, ensuring fixed costs are hard coded into the model (variable costs are stated as a percentage of the relevant activity measures or as a cost per unit of activity measure). d) Add actual activity measures to the model. Make sure all information is added accurately. e) Add the flexible budget calculations to the budget model. Make sure all information is accurate. f) Compare the flexible budget to the actual expenses. What does this inform? Be sure to discuss the following variances :i. Static budget variance, including sales volume and flexible budget variances ii. Price and efficiency variances for direct materials and direct labor. iii. Spending and efficiency variances for variable manufacturing overhead) Determine the aspects of the budgeting process that are in need of improvement. Justify your response.h) Interpret what budget variances represent. Should all variances be investigated?Guidelines for Submission: Your paper must be submitted using the Student Workbook to present your budgets and variances and a 1?2 page Microsoft Word document with double spacing, 12-point Times New Roman font, and one-inch margins to explain your findings.





ACC 207 MDE Manufacturing Budget: Bird Feeder

 

I. Sales and Manufacturing Expenses: Budget and Actual (2014) You will use this table to complete Milestones One and Two.

 

Budget ($) Actual ($) 1,050,000 991,700 Expenses

 

Materials ? Cedar

 

Materials ? Plastic

 

Factory Worker Labor

 

Materials ? Indirect

 

Factory Depreciation

 

Factory Utilities

 

Factory Maintenance and Repairs

 

Shipping ($2.25/each)

 

Sales Commissions ($2.00/unit sold)

 

Office Rent

 

Advertising

 

Liability insurance

 

Office Depreciation

 

Office Salaries 225,000

 

37,500

 

300,000

 

3,000

 

78,000

 

12,000

 

5,000

 

112,500

 

100,000

 

12,000

 

20,000

 

5,000

 

1,000

 

48,000 248,160

 

37,741

 

332,760

 

2,585

 

78,000

 

12,000

 

4,500

 

105,750

 

94,000

 

12,000

 

20,000

 

5,000

 

1,000

 

48,000 Total Expenses 959,000 1,001,496 Sales II. Contribution Margin: Static Budget and Actual Results (2014) You will use this table to complete Milestone Two. Units Sold

 

Revenues ($)

 

Manufacturing Costs ($)

 

Variable

 

Fixed

 

Gross Margin Actual Results Static Budget Amount 47,000

 

991,700 50,000

 

1,050,000 621,246

 

94,500

 

275,954 565,500

 

95,000

 

389,500 III. Standard Variable Manufacturing Costs (2014) You will use this table to complete Milestone Two.

 

Static Budget Costs Standard Input 225,000

 

37,500

 

300,000

 

3,000 3.0 ft/unit

 

1.0 ft/unit

 

0.5 hrs/unit

 

0.3 ft/unit Direct Materials: Cedar

 

Direct Materials: Plastic

 

Direct Manufacturing Labor

 

Variable Manufacturing Overhead IV. Actual Variable Manufacturing Costs (2014) You will use this table to complete Milestone Two. Direct Materials: Cedar

 

Direct Materials: Plastic

 

Direct Manufacturing: Labor ($)

 

Variable Manufacturing Overhead Actual Costs Actual Input 248,160

 

37,741

 

332,760

 

2,585 3.2 ft/unit

 

1.1 ft/unit

 

.60 hr/unit

 

0.25 ft/unit

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Sep 18, 2020

PRICE: $15

Solution~0001003931.zip (25.37 KB)

Buy this answer for only: $15

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy from our tutoring website www.aceyourhomework.com (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 18, 2020

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN YOUR SET DEADLINE.

Order Now