Budget Excel Project - Astro Co. Astro Corporation is preparing its budget for the coming year,...
Fantastic news! We've Found the answer you've been seeking!
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6655e43e8686b_0226655e43e7dbaf.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6655e43ed583d_0226655e43ecee61.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6655e43f2bb21_0236655e43f21f0f.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6655e43f74074_0236655e43f6e3b9.jpg)
Transcribed Image Text:
Budget Excel Project - Astro Co. Astro Corporation is preparing its budget for the coming year, 2020. The first step is to plan for the first quarter of that coming year. The company has gathered information from its managers in preparation of the budgeting process. Sales Unit sales for November 2019 Unit sales for December 2019 Expected unit sales for January 2020 Expected unit sales for February 2020 Expected unit sales for March 2020 Expected unit sales for April 2020 Expected unit sales for May 2020 Unit selling price 112,500 102,100 113,000 112,500 116,000 125,000 137,500 $12 Astro likes to keep 10% of the next month's unit sales in ending inventory. All sales are on account. 85% of the Accounts Receivable are collected in the month of sale, and 15% of the Accounts Receivable are collected in the month after sale. Accounts receivable on December 31, 2019, totalled $183,780. Direct Materials Direct materials cost 75 cents per pound. Two pounds of direct materials are required to produce each unit. Astro likes to keep 5% of the materials needed for the next month in its ending inventory. Raw Materials on December 31, 2019 were 11,295 pounds. Payment for materials is made within 15 days. 50% is paid in the month of purchase, and 50% is paid in the month after purchase. Accounts Payable balance on December 31, 2019 was $120,595. Direct Labor Labor requires 12 minutes per unit for completion and is paid at a rate of $8 per hour. Manufacturing Overhead Indirect materials Indirect labor 30 per labor hour 50 per labor hour Utilities Maintenance Salaries 45 per labor hour 25 per labor hour $42,000 per month $16,800 per month Depreciation Property taxes $2,675 per month Insurance $1,200 per month Janitorial $1,300 per month Budget Excel Project - Astro Co. Astro Corporation is preparing its budget for the coming year, 2020. The first step is to plan for the first quarter of that coming year. The company has gathered information from its managers in preparation of the budgeting process. Sales Unit sales for November 2019 Unit sales for December 2019 Expected unit sales for January 2020 Expected unit sales for February 2020 Expected unit sales for March 2020 Expected unit sales for April 2020 Expected unit sales for May 2020 Unit selling price 112,500 102,100 113,000 112,500 116,000 125,000 137,500 $12 Astro likes to keep 10% of the next month's unit sales in ending inventory. All sales are on account. 85% of the Accounts Receivable are collected in the month of sale, and 15% of the Accounts Receivable are collected in the month after sale. Accounts receivable on December 31, 2019, totalled $183,780. Direct Materials Direct materials cost 75 cents per pound. Two pounds of direct materials are required to produce each unit. Astro likes to keep 5% of the materials needed for the next month in its ending inventory. Raw Materials on December 31, 2019 were 11,295 pounds. Payment for materials is made within 15 days. 50% is paid in the month of purchase, and 50% is paid in the month after purchase. Accounts Payable balance on December 31, 2019 was $120,595. Direct Labor Labor requires 12 minutes per unit for completion and is paid at a rate of $8 per hour. Manufacturing Overhead Indirect materials Indirect labor 30 per labor hour 50 per labor hour Utilities Maintenance Salaries 45 per labor hour 25 per labor hour $42,000 per month $16,800 per month Depreciation Property taxes $2,675 per month Insurance $1,200 per month Janitorial $1,300 per month
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
Consider again the American Telephone & Telegraph 818 percent debentures that mature on July 15, 2024. Determine the yield to call if the bonds are called on July 15, 2010 at $1,016.55.
-
If Firm B had a 75% payout ratio but then lowered it to 25%, causing its growth rate to rise from 3% to 9%, would that action necessarily increase the price of its stock? Why or why not?
-
In my Chevrolet (2.2) The Chevrolet Malibu with a four-cylinder engine has a combined gas mileage of 25 mpg. What percent of all vehicles have worse gas mileage than the Malibu?
-
J.C. Penney, a retail merchandiser, has its principal place of business in Plano, Texas. It operates retail stores in all 50 states, including 10 stores in Massachusetts, and a direct mail catalog...
-
1,2,3,4 please Actual run time this week Machine time available per week Actual run rate this week Ideal run rate Defect-free output this week Total output this week (including defects) 6,880 minutes...
-
Please help me with this Question 4 (4 points) Write the vector (-10, -34) as a linear combination of the vectors (-1, 3) and (1. 5). a. Set up the x and y components to find a and b. Show your...
-
Test - LOG 2060 Intermediate Systems Sustainment Management T07.E02 Describe DoD's Depot Maintenance Enterprise and How Core, 50-50, and Partnering Initiatives Question 30 of 31. In depot...
-
Assuming that StickerGiant plans to expand its business to overseas markets, what are the top 3 environmental factors (economic, political/legal, demographic, social, competitive, global, and...
-
Selina is an avid sky diver. How would an insurer rate the severity/probability of the risks to which Selina is exposed? a) minor/low b) critical/high c) material/medium d) critical/low
-
Primare Corporation has provided the following data concerning last month's manufacturing operations. Purchases of raw materials Indirect materials used in production Direct labor Manufacturing...
-
Perpendicular Offset Practice Problem Find the perpendicular offset and station of Point K relative to line JL. Point K N 2423.58 Point L. Point J N 2537.19 N 2399.34 E 1774.94 E 2223.41 E 2445.15
-
A classmate shared a study guide for matrix regression, and I do not understand how they got the matrix model (X) result. Can someone explain this to me? \f
-
What to do With a Million Dollars You have inherited $1 million! Required Describe the process you will go through in determining how to invest your inheritance. Consider at least two options and...
-
Corrected Financial Statements Hometown Cleaners Inc. operates a small dry-cleaning business. The company has al- ways maintained a complete and accurate set of records. Unfortunately, the company's...
-
Effect of Forms of Organization on Accounting for the Entity Entities can be organized as sole proprietorships, partnerships, or corporations. The fol- lowing is a list of entities: 1. A landscaping...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App