To demonstrate your understanding of the master budget and all of the supporting budgets, use the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
To demonstrate your understanding of the master budget and all of the supporting budgets, use the data set provided below to complete a comprehensive budget problem for the MORRISSEY Company. Submit the finished document to your instructor through this Canvas assignment link. You must prepare the assignment in Excel using the template provided (located in Module 10, Assignment Overview). You must use formulas and link the budgets wherever possible, as indicated below in the grading criteria. Data Set MORRISSEY Company is preparing its master budget for the first quarter of the upcoming year. The following data pertain to MORRISSEY Company's operations: Relevant Account Balances as of December 31 (prior year): Cash - $6,000 Accounts Receivable, net - $57,000 Inventory - $13,000 Accounts Payable - $22,000 Most of the labor at the manufacturing facility is indirect, but there is some direct labor incurred. Each unit requires .03 direct labor hours. The direct labor wage rate is $13 per hour. All direct labor is paid for in the month in which the work is performed. Monthly manufacturing overhead costs are $6,500 for factory rent, $2,100 for other fixed manufacturing expenses, and $1.40 per unit for variable manufacturing overhead. No depreciation is included in these figures. All expenses are paid for in the month in which they are incurred. Operating expenses are budgeted to be $1.20 per unit sold plus fixed operating expenses of $1,400 per month. All operating expenses are paid in the month in which they are incurred. Computer equipment for the administrative offices will be purchased in the upcoming quarter. In January, MORRISSEY Company will purchase equipment for $15,000 (cash), while February's cash expenditures will be $6,000, and March's cash expenditure will be $4,000. MORRISSEY Company has a policy that the ending cash balance in each month must be at least $4,400. It has a line of credit with a local bank. The company can borrow in increments of $1,000 at the beginning of each month, up to a total outstanding loan balance of $100,000. The interest rate on these loans is 1.5% per month simple interest (not compounded). The company would pay down on the line of credit balance in increments of $1,000 if it has excess funds at the end of the quarter. The company would also pay the accumulated interest at the end of the quarter on the funds borrowed during the quarter. Finally, the company pays $10,800 cash at the end of February in estimated taxes. To demonstrate your understanding of the master budget and all of the supporting budgets, use the data set provided below to complete a comprehensive budget problem for the MORRISSEY Company. Submit the finished document to your instructor through this Canvas assignment link. You must prepare the assignment in Excel using the template provided (located in Module 10, Assignment Overview). You must use formulas and link the budgets wherever possible, as indicated below in the grading criteria. Data Set MORRISSEY Company is preparing its master budget for the first quarter of the upcoming year. The following data pertain to MORRISSEY Company's operations: Relevant Account Balances as of December 31 (prior year): Cash - $6,000 Accounts Receivable, net - $57,000 Inventory - $13,000 Accounts Payable - $22,000 Most of the labor at the manufacturing facility is indirect, but there is some direct labor incurred. Each unit requires .03 direct labor hours. The direct labor wage rate is $13 per hour. All direct labor is paid for in the month in which the work is performed. Monthly manufacturing overhead costs are $6,500 for factory rent, $2,100 for other fixed manufacturing expenses, and $1.40 per unit for variable manufacturing overhead. No depreciation is included in these figures. All expenses are paid for in the month in which they are incurred. Operating expenses are budgeted to be $1.20 per unit sold plus fixed operating expenses of $1,400 per month. All operating expenses are paid in the month in which they are incurred. Computer equipment for the administrative offices will be purchased in the upcoming quarter. In January, MORRISSEY Company will purchase equipment for $15,000 (cash), while February's cash expenditures will be $6,000, and March's cash expenditure will be $4,000. MORRISSEY Company has a policy that the ending cash balance in each month must be at least $4,400. It has a line of credit with a local bank. The company can borrow in increments of $1,000 at the beginning of each month, up to a total outstanding loan balance of $100,000. The interest rate on these loans is 1.5% per month simple interest (not compounded). The company would pay down on the line of credit balance in increments of $1,000 if it has excess funds at the end of the quarter. The company would also pay the accumulated interest at the end of the quarter on the funds borrowed during the quarter. Finally, the company pays $10,800 cash at the end of February in estimated taxes.
Expert Answer:
Answer rating: 100% (QA)
Here are the stepbystep workings to complete the MORRISSEY Company master budget Sales Budget No sal... View the full answer
Related Book For
The Legal and Regulatory Environment of Business
ISBN: 978-0078023859
17th edition
Authors: Marisa Pagnattaro, Daniel Cahoy, Manning Magid, Lee Reed, Pe
Posted Date:
Students also viewed these accounting questions
-
To demonstrate your understanding of the concepts behind stockholders equity and the transactions which support it, read the scenario below and discuss: al and ed, friends since childhood, decided to...
-
As a student, you need to demonstrate your understanding in conducting the three stages of strategy including strategy formulation, implementation and evaluation Therefore, you need to select an...
-
This problem tests your understanding of the chapter appendix. A company is considering the following investment opportunities. a. If the company can raise large amounts of money at an annual cost of...
-
Shalom Company projects the following operating results next year: Produced 70,000 units Sales 60,000 units Sales price 10 per unit Total fixed cost 300,000 per year Total variable cost 20% of sales...
-
Describe the three basic functions of law, and explain the importance of each to the U. S. judicial system.
-
In Exercises 15 through 44, evaluate the given definite integral using the fundamental theorem of calculus. L ( 1 - - 1 - ) d x dx e
-
A lossless motor drives the fan shown in Fig. P12.40 at \(40 \mathrm{~Hz}\). The power input to the motor is \(40 \mathrm{amps}\) at 440 volts. For the geometry shown, what is the discharge flow rate...
-
Christensen Shipyards built a 155-foot yacht for Tiger Woods at its Vancouver, Washington, facilities. It used Tigers name and photographs relating to the building of the yacht in promotional...
-
Read the following CBC News article titled "Stobbe's lawyer highlights unknown DNA in defence". Pretend you are a juror hearing this information for the first time, and in a well-developed paragraph...
-
Tamar Company manufactures a single product in two departments: Forming and Assembly. Information for the Forming process for May follows. Beginning work in process inventory Units started this...
-
A man bought a condominium unit worth P3.9M a pay a down payment of P1.5M and agreed to pay the remaining balance as follows: P600,000 at the end of the 2nd year; P755,000 at the beginning of the 5th...
-
What are the different types of private insurers?
-
Outline the benefits of a consultative sales process.
-
What do you understand by personal selling?
-
What is excess zone with regard to communications style? Why might people drift into this zone?
-
What is nonoperating income?
-
Given the following snippet of VBA code .... A = 6 B = 13 If A > B Then X = A + B ElseIf B > A Then X = B - A Else X = B End If What is the value of X when the code is executed?
-
Write a while loop that uses an explicit iterator to accomplish the same thing as Exercise 7.3. Exercise 7.3. Write a for-each loop that calls the addInterest method on each BankAccount object in a...
-
As the chief executive officer of a Silicon Valley software company, you become aware that your chief competitor is working on a new computer program that will revolutionize interactive voice-based...
-
(a) What are the sanctions for criminal conduct. (b) Name three purposes of criminal sanctions.
-
Define judicial activism. Compare and contrast judicial restraint and judicial activism.
-
The weights (in pounds) for a sample of adults before starting a weight-loss study are listed. What is the mean weight of the adults? 274 235 223 268 290 285 235
-
In Example 2, the adult weighing 285 pounds decides to not participate in the study. What is the median weight of the remaining adults? Data from Example 2 Find the median of the weights listed in...
-
Find the median of the weights listed in Example 1. Data from Example 1 The weights (in pounds) for a sample of adults before starting a weight-loss study are listed. What is the mean weight of the...
Study smarter with the SolutionInn App