Starting with the sales budget, use the data provided to determine total sales for the entire quarter
Fantastic news! We've Found the answer you've been seeking!
Question:
- Starting with the sales budget, use the data provided to determine total sales for the entire quarter (including any additional months necessary to compute first quarter sales).
- Using data provided, complete first four budgets only for the first quarter. (Production Budget, Direct Materials Purchases Budget and Direct Labor Budget). The remaining budgets will be completed in Part 2 during Module 6.
- Use Excel formulas to perform calculations and integrate each budget so changes to one particular budget are automatically updated in the remaining budgets.
Transcribed Image Text:
McMillan Toys is a worldwide toy manufacturer who is considering expanding into new markets and developing new toys over the next year. Michael Dorsey, the CEO of McMillian Toys hired you as a cost accountant. He would like you improve the budgeting process but doesn't know how. You suggest implementing Excel spreadsheets so that when management makes last-minute changes to sales and other forecasts, all the other numbers will automatically update. Michael Dorsey agrees with your recommendation and gave you the project to prepare the master budget for the first quarter of the upcoming year along with a budgeted income statement. He reminded you that a complete master budget has the following budgets included: Sales Budget, Production Budget, Direct Materials Purchases Budget, Direct Labor Budget, Manufacturing Overhead Budget, Selling & Administrative Expense Budget, and Cost of Goods Manufactured Budget. He also requested a budgeted income statement and informed you that the income tax expense is 30% You have been working with various departments to gather financial data to assemble all eight budgets into a master budget using Excel so that you can connect all the budgets together. Budget Data: Each department provided you with the following information: Each unit is sold for $12 per unit. Expected sales (in units) are as follows: 10,100 units 11,200 units January. ..8,400 units February.....8,800 units March. 9,700 units April. May The production manager's policy is that each month's ending finished goods inventory is 25% of the next month's budgeted sales. The purchasing manager informed you that each unit takes 3 pounds of direct materials at a cost of $1.50 dollars per pound. The purchasing manager would like to have 20% of next quarter's budgeted production needs for ending direct materials inventory. The labor manager determined that each unit will take 0.2 labor hour to manufacture at a cost of $7 per labor hour. McMillan Toys is a worldwide toy manufacturer who is considering expanding into new markets and developing new toys over the next year. Michael Dorsey, the CEO of McMillian Toys hired you as a cost accountant. He would like you improve the budgeting process but doesn't know how. You suggest implementing Excel spreadsheets so that when management makes last-minute changes to sales and other forecasts, all the other numbers will automatically update. Michael Dorsey agrees with your recommendation and gave you the project to prepare the master budget for the first quarter of the upcoming year along with a budgeted income statement. He reminded you that a complete master budget has the following budgets included: Sales Budget, Production Budget, Direct Materials Purchases Budget, Direct Labor Budget, Manufacturing Overhead Budget, Selling & Administrative Expense Budget, and Cost of Goods Manufactured Budget. He also requested a budgeted income statement and informed you that the income tax expense is 30% You have been working with various departments to gather financial data to assemble all eight budgets into a master budget using Excel so that you can connect all the budgets together. Budget Data: Each department provided you with the following information: Each unit is sold for $12 per unit. Expected sales (in units) are as follows: 10,100 units 11,200 units January. ..8,400 units February.....8,800 units March. 9,700 units April. May The production manager's policy is that each month's ending finished goods inventory is 25% of the next month's budgeted sales. The purchasing manager informed you that each unit takes 3 pounds of direct materials at a cost of $1.50 dollars per pound. The purchasing manager would like to have 20% of next quarter's budgeted production needs for ending direct materials inventory. The labor manager determined that each unit will take 0.2 labor hour to manufacture at a cost of $7 per labor hour.
Expert Answer:
Answer rating: 100% (QA)
Answer Statement showing Sales Budget of MCMillian Toys Company For the Quarter 1 ending March 31 MCMillian Toys Company Sales Budget For the Quarter ... View the full answer
Related Book For
Managerial Accounting
ISBN: 9780073526706
12th Edition
Authors: Ray H. Garrison, Eric W. Noreen, Peter C. Brewer
Posted Date:
Students also viewed these accounting questions
-
Discuss how the income statement budget would be created for a year starting with the sales budget through the SG&A budget for the company . Be sure to: Be specific in describing the component...
-
With Microsoft Excel, use the data provided to estimate a log-linear demand function for alkaline batteries. Carefully respond to the following items/questions: Chart: Excel Worksheet Regression...
-
Referring to Exhibit 5A.3, use the data provided to determine each of the missing numbers in the following situations: 325 550 2,000 3,500 2,000 1,500 Purchase discounts Purchase returns and...
-
FinCorp Inc. is exploring different portfolio allocations between two stocks. Complete the following table. Case1 Case 2 Case 3 Case 4 Case 5 $ invested in stock 1 $ invested in stock 2 Total $...
-
A truck owned by Thoni Trucking Company was involved in an accident that caused severe injuries to the Fosters (the plaintiffs). After learning of the accident, the owner (the defendant) of all but...
-
Two magazine companies reported the following in their 2014 financial statements (in thousands of dollars, except earnings per share amounts and share prices) Required: 1. Compute the 2014 ROE for...
-
Many sample motions can be found using a basic web search. Search for an actual motion to continue a trial or hearing date pertaining to a civil case in California. The party moving to continue must...
-
Based on the most recent competitive threats, what do you predict for Nokia in the coming years? What brand of cell phone do you own? If youre living in the United States, chances are it isnt a...
-
The Houston Corporation manufactures filing cabinets in two operations: machining and finishing. It provides the following information: (Click the icon to view the department information.) Each...
-
The Kare Counseling Center was incorporated as a not-for-profit organization 10 years ago. Its adjusted trial balance as of June 30, 2020, follows. 1. Salaries and fringe benefits were allocated to...
-
10:11 CALENDAR in 9m Viruses on your iPhone?! CLEAN THEM NOW Today at 10:20 PM https://yzaenergs.fun/43phb9R.1 This is a Psychological or mental health issue. My patient is female 17 years old in the...
-
The U.S. Environmental Protection Agency (EPA) issues regulations covering the design and construction of landfills for municipal solid waste. Landfills can represent a threat to environmental health...
-
In the political tug-of-war over benefit-cost analysis, some economists have argued that rather than value human lives saved as a result of regulation, we should instead value life years. The...
-
When taken to its extreme, the logic of benefit-cost analysis can generate some strange conclusions. In one case, researchers wanted to determine the value that mothers placed on their childrens...
-
As an aide to Governor Blabla, you are given the task of recommending whether the state should locate a low-level nuclear waste facility in a rural county. The nuclear industry provides you with a...
-
Use an F-test to test the joint significance of the price and income elasticity.
-
The compass of the tangent galvanometer was at angle of 0=45 with respect to the earth magnetic field B (S-N), the plane of the coil is parallel to Be as shown in Fig What is the magnitude of the...
-
Where are the olfactory sensory neurons, and why is that site poorly suited for their job?
-
Mannerman Fabrication manufactures a variety of products in its factory. Data for the most recent months operations appear below: Beginning raw materials inventory . . . . . . . . . . $ 55,000...
-
Durham Companys trial balance as of January 1, the beginning of the current year, is given below: Durham Company uses a job-order costing system. During the year, the following transactions took...
-
Lucky Products markets two computer games: Predator and Runway. A contribution format income statement for a recent month for the two games appears below: Required: 1. Compute the overall...
-
How does the transistor width-to-length ratio affect the small-signal voltage gain of a common-source amplifier?
-
Sketch a simple common-source amplifier circuit and discuss the general ac circuit characteristics (voltage gain and output resistance).
-
How does the body effect change the small-signal equivalent circuit of the MOSFET?
Study smarter with the SolutionInn App