Use Excel to prepare the following budgets for March 2020: 1. Sales budget 2. Production budget...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Use Excel to prepare the following budgets for March 2020: 1. Sales budget 2. Production budget 3. Direct materials purchases budget 4. Direct labor cost budget 5. Factory overhead cost budget 6. Costs of goods sold budget. Work in process at the beginning of March is estimated to be $11,000, and work in process at the ending of March is desired to be $12,500. 7. Selling and administrative expenses budget 8. Budgeted income statement The budget director of Athletic Supplies Inc., with the assistance of the controller, treasurer. production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for March: a. Estimated sales for March: Batting helmet Football helmet b. Estimated inventories at March 1: Direct materials: Plastic Foam lining Finished products: Batting helmet Football helmet c. Desired inventories at March 31:1 Direct materials: Plastic Foam lining Finished products: Batting helmet Football helmet Plastic Foam lining 1,100 units at $42 per unit 6,400 units at $146 per unit In manufacture of football helmet: Foam lining f. Direct labor requirements: Batting helmet: d. Direct materials used in production: In manufacture of batting helmet: Molding Department Assembly Department Football helmet: 55 lbs. 65 lbs. Molding Department Assembly Department 75 units at $28 per unit 220 units at $75 per unit 70 lbs. 74 lbs. Plastic Foam lining 3.5 lbs. per unit of product 1.75 lbs. per unit of product e. Anticipated cost of purchases and beginning and ending inventory of direct materials: Plastic $5.4 per lb. $3.6 per lb. 50 units at $27 per unit 225 units at $72 per unit 1.5 lbs. per unit of product 0.75 lb. per unit of product 0.3 hr. at $21 per hr. 0.6 hr. at $15 per hr. 0.8 hr. at $21 per hr. 1.6 hrs. at $15 per hr. g. Estimated factory overhead costs for March: Indirect factory wages Depreciation of plant and equipment Power and light Insurance and property tax h. Estimated operating expenses for March: Sales salaries expense Advertising expense Office salaries expense Depreciation expense-office equipment Telephone expense-selling Telephone expense-administrative Travel expense-selling Office supplies expense Miscellaneous administrative expense i. Estimated other income and expense for March: Interest revenue Interest expense J. Estimated tax rate: 30% $75,000 14,000 3,000 3,700 $186,200 88,200 33,500 5,000 3,900 1,500 10,000 1,500 2,200 800 875 Use Excel to prepare the following budgets for March 2020: 1. Sales budget 2. Production budget 3. Direct materials purchases budget 4. Direct labor cost budget 5. Factory overhead cost budget 6. Costs of goods sold budget. Work in process at the beginning of March is estimated to be $11,000, and work in process at the ending of March is desired to be $12,500. 7. Selling and administrative expenses budget 8. Budgeted income statement The budget director of Athletic Supplies Inc., with the assistance of the controller, treasurer. production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for March: a. Estimated sales for March: Batting helmet Football helmet b. Estimated inventories at March 1: Direct materials: Plastic Foam lining Finished products: Batting helmet Football helmet c. Desired inventories at March 31:1 Direct materials: Plastic Foam lining Finished products: Batting helmet Football helmet Plastic Foam lining 1,100 units at $42 per unit 6,400 units at $146 per unit In manufacture of football helmet: Foam lining f. Direct labor requirements: Batting helmet: d. Direct materials used in production: In manufacture of batting helmet: Molding Department Assembly Department Football helmet: 55 lbs. 65 lbs. Molding Department Assembly Department 75 units at $28 per unit 220 units at $75 per unit 70 lbs. 74 lbs. Plastic Foam lining 3.5 lbs. per unit of product 1.75 lbs. per unit of product e. Anticipated cost of purchases and beginning and ending inventory of direct materials: Plastic $5.4 per lb. $3.6 per lb. 50 units at $27 per unit 225 units at $72 per unit 1.5 lbs. per unit of product 0.75 lb. per unit of product 0.3 hr. at $21 per hr. 0.6 hr. at $15 per hr. 0.8 hr. at $21 per hr. 1.6 hrs. at $15 per hr. g. Estimated factory overhead costs for March: Indirect factory wages Depreciation of plant and equipment Power and light Insurance and property tax h. Estimated operating expenses for March: Sales salaries expense Advertising expense Office salaries expense Depreciation expense-office equipment Telephone expense-selling Telephone expense-administrative Travel expense-selling Office supplies expense Miscellaneous administrative expense i. Estimated other income and expense for March: Interest revenue Interest expense J. Estimated tax rate: 30% $75,000 14,000 3,000 3,700 $186,200 88,200 33,500 5,000 3,900 1,500 10,000 1,500 2,200 800 875
Expert Answer:
Related Book For
Financial and Managerial Accounting
ISBN: 978-0538480895
11th Edition
Authors: Jonathan E. Duchac, James M. Reeve, Carl S. Warren
Posted Date:
Students also viewed these accounting questions
-
Halicon Ltd. applies LCNRV valuation. The companys inventory at the end of the year is as follows: Required: Determine the amount of any adjustment that is required to inventory, assuming inventory...
-
The inventory at the end of the year was understated by $23,950. (a) Did the error cause an overstatement or an understatement of the gross profit for the year? (b) Which items on the balance sheet...
-
The inventory at the end of the year was understated by $8,750. (a) Did the error cause an overstatement or an understatement of the gross profit for the year? (b) Which items on the balance sheet at...
-
Given the following set of slope staking notes: C Sta 51+00 50+00 49+00 L CX 33.4 F 9.1 33.6. F 10.3 35.4 C 5.5 0.0 F 3.5 R C 3.2 X C 4.1 30.2 0.0 20.0 Bases Base for cut=48 ft Base for fill= 40 ft s...
-
For the quantities in the population ANOVA table (Table 5.1), show that And MSW = NM-1 S-(1-ICC) NM MSBN M(N 1)
-
Suppose you are an analyst developing a new information system to automate the sales transactions and manage inventory for each retail store in a large chain. The system would be installed at each...
-
If the sample size is small, the differences between the items in the matched pairs must show no evidence of strong and must contain no ______________ . In Exercises 3 and 4, fill in each blank with...
-
Freya is an accountant working on the tax return of a high- tech client. After reviewing the work papers, she discovers that there is a pattern of double billing the U. S. Navy for various projects...
-
Does the process of globalization help or hinder wealth creation in developing countries? British petroleum' global activities for diplomatic/political to support your findings and conclusion...
-
1. Determinewhether differences exist in the relationship status and the self rated fitness based on the product purchased ( TM195, TM498, TM798). 2. Write a report to be presented to the management...
-
Walmart Stores, Inc ;The tool of strategic analysis . 1. What is Walmart's competitive advantage? 2. Is their competitive advantage sustainable and why? 3. Why has Wal-Mart been successful? 4. What...
-
XYZ, Inc. had the following Stockholder's Equity Balances as of 1/1/21: Preferred Stock500 shares @ $100 par value $500,000 Common Stock10,000 shares @ $10 par value $100,000 Additional Paid-in...
-
Two parallel plates are set up with one 1.80 m above the other. The bottom plate has an electric potential of zero and the top has an electric potential of 3.37x106 V. A charged ball of mass 0.800 g...
-
Q1. A swimmer does 6.7 105J of work and gives off 4.1 10J of heat during a workout. Determine U, W, and Q for the swimmer- Q2. When heat is added to one mole of an ideal monatomic gas, its internal...
-
What are the competitive advantage priorities? which are used by the major Organizations.
-
Calculate of the short-term debt paying ratios. Calculate the long-term debt paying or financial leverage ratios. Calculate the five significant asset utilization or turnover ratios....
-
b. Draw a profit or loss graph for selling a call contract with an exercise price of $13 and a $4 selling price (the premium). You may assume that the option is being evaluated on its expiration...
-
Burberrys competitive advantage is through its differentiation strategy. What risk should Burberry remain aware of?
-
Based on the following data, determine the cost of merchandise sold for April: Merchandise inventory, April 1 $ 15,000 Merchandise inventory April 30 28,000 Purchases 290,000 Purchases returns and...
-
Anwar Askari is planning to manage and operate AA Caddy Service at Mission Valley Golf and Country Club during June through August 2012. Anwar will rent a small maintenance building from the country...
-
The controller of Fleet Shoes Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: The company expects to sell about...
-
The mean free path \(\lambda\) of a molecule of gas is the average distance it travels before collision with another molecule. It is given by \[\lambda=C \frac{m}{ho d^{2}}\] where \(m\) and \(d\)...
-
A rectangular gate (width \(w=2 \mathrm{~m}\) ) is hinged as shown, with a stop on the lower edge. At what depth \(H\) will the gate tip? Water H 0.55 m 0.45 m P3.46 Hinge Stop
-
Gates in the Poe Lock at Sault Ste. Marie, Michigan, close a channel \(W=34 \mathrm{~m}\) wide, \(L=360 \mathrm{~m}\) long, and \(D=10 \mathrm{~m}\) deep. The geometry of one pair of gates is shown;...
Study smarter with the SolutionInn App