Purchase Solution

Cost Accounting-Master budget-Prepare the following schedule

Not what you're looking for?

Ask Custom Question

prepare the required schedules in the Excel sheet and LINK ALL possible calculations to this worksheet, or to calculations from the budget schedules.

REQUIREMENTS:
You will be given an Excel file of this worksheet as the basis for the following exercises.
As you prepare each of the following budget schedules, you are required to link all
possible calculations to this worksheet, or to calculations from the budget schedules.

Prepare the following schedules to support the Budgeted Income Statement in Schedule I:
(a) Sales budget (check figure: $6,910,000)
(b) Production budget in units (check figure: Product G units = 1,000)
(c ) Direct materials purchases budget (check figure: Total DM purchases = $2,060,000)
Include calculation of Direct Materials used (check figure: $2,152,000)
(d) Direct Labor budget (check figure: $2,132,000)
(e) Factory Overhead budget showing fixed and variable subtotals and overhead application rate
(check figure: Factory OH application rate = $20 per DL hour)
(f) Ending inventory budget including calculation of FG unit costs (check figure: Combined
Ending Inventory cost = $1,109,800)
(g) Cost of Goods Sold budget (check figure: $5,497,000)
(h) Selling and Administrative budget with categories (check figure: $750,000)
(i) Budgeted Income Statement for 2008 through Operating Income (check figure: $663,000)

Attachments
Purchase this Solution

Solution Summary

Your tutorial is in excel with amounts all linked to the data sheet and all computations in cells.

Solution provided by:
Education
  • BSc, University of Virginia
  • MSc, University of Virginia
  • PhD, Georgia State University
Recent Feedback
  • "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
  • "Thank, this is more clear to me now."
  • "Awesome job! "
  • "ty"
  • "Great Analysis, thank you so much"
Purchase this Solution


Free BrainMass Quizzes
Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.

Basics of corporate finance

These questions will test you on your knowledge of finance.

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.