to create an area of the spreadsheet for data entry, while the rest of the spreadsheet...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
to create an area of the spreadsheet for data entry, while the rest of the spreadsheet uses the information entered in those cells to solve the problem. The numbers given should all be put in the data entry area, labeled clearly as to what each represents. The answers to the questions below should also be clearly labeled. Your spreadsheet should work to produce answers to the questions regardless of what numbers are put into the data entry area; for example, if I change expected sales volume in April to 2,000, your spreadsheet should automatically recalculate the budget numbers to yield the appropriate answers at that sales volume. The following information is available for Boostarama Company: Expected sales volume: April May June July 1,430 units 1,800 units 1,750 units 1,000 units Selling price per unit Beginning finished goods inventory, April 1 (210 units) Direct materials needed per unit Total direct labor time per finished unit of product Direct materials cost per pound Direct labor cost per hour Additional information: a. b. C. Font $30 $5,250 5 pounds 2 hours $0.50 $8 The desired finished goods inventory every month is 15% of the next month's sales. Variable manufacturing overhead is applied based on direct labor hours. Variable manufacturing overhead rate is $2.40/DLH. Fixed overhead costs are $3,200 per month. Period expenses are $5,000 per month. REQUIRED (Please show budgets for the individual months as well as for the Quarter): Prepare sales budgets for the second Quarter. 1. 2. Prepare production budgets for the second Quarter. 3. 4. Prepare direct materials budgets for the second Quarter. Prepare direct labor budgets for the second Quarter. 5. Prepare manufacturing overhead budgets for the second Quarter. 6. 7. Prepare ending finished goods budgets for the second Quarter. Prepare cost of goods sold budgets for the second Quarter. 8. Prepare a budgeted income statement for the second Quarter. All cells should be formula-driven except those in the input area. Points will be deducted if the calculations include direct entry of data. Submit your completed Excel file to to create an area of the spreadsheet for data entry, while the rest of the spreadsheet uses the information entered in those cells to solve the problem. The numbers given should all be put in the data entry area, labeled clearly as to what each represents. The answers to the questions below should also be clearly labeled. Your spreadsheet should work to produce answers to the questions regardless of what numbers are put into the data entry area; for example, if I change expected sales volume in April to 2,000, your spreadsheet should automatically recalculate the budget numbers to yield the appropriate answers at that sales volume. The following information is available for Boostarama Company: Expected sales volume: April May June July 1,430 units 1,800 units 1,750 units 1,000 units Selling price per unit Beginning finished goods inventory, April 1 (210 units) Direct materials needed per unit Total direct labor time per finished unit of product Direct materials cost per pound Direct labor cost per hour Additional information: a. b. C. Font $30 $5,250 5 pounds 2 hours $0.50 $8 The desired finished goods inventory every month is 15% of the next month's sales. Variable manufacturing overhead is applied based on direct labor hours. Variable manufacturing overhead rate is $2.40/DLH. Fixed overhead costs are $3,200 per month. Period expenses are $5,000 per month. REQUIRED (Please show budgets for the individual months as well as for the Quarter): Prepare sales budgets for the second Quarter. 1. 2. Prepare production budgets for the second Quarter. 3. 4. Prepare direct materials budgets for the second Quarter. Prepare direct labor budgets for the second Quarter. 5. Prepare manufacturing overhead budgets for the second Quarter. 6. 7. Prepare ending finished goods budgets for the second Quarter. Prepare cost of goods sold budgets for the second Quarter. 8. Prepare a budgeted income statement for the second Quarter. All cells should be formula-driven except those in the input area. Points will be deducted if the calculations include direct entry of data. Submit your completed Excel file to
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
12:58 PM Tue Feb 20 + 18% AA ezto.mheducation.com Tennessee State University D2L Homepage - Prin Manageri... M Question 1- Ch 17: Assign... B BVT Publishing - Business... Course Hero Ch 17:...
-
The registrar at a prominent northeastern university recently scheduled an instructor to teach two different classes at the same exact time. Help the registrar prevent future mistakes by describing a...
-
The Dream Kitchen is a small chain of kitchen remodeling stores. The company's year-end trial balance on December 31, 2016, included the information shown below: Accounts Receivable...
-
Suppose we want to create a random sample of the set {1, 2, 3, . . . , n}, that is, an m-element subset S, where 0 m n, such that each m-subset is equally likely to be created. One way would be to...
-
What would be the procedure for producing uniform workplace illuminance when both sidelighting and skylighting are used simultaneously?
-
The Metropolitan Housing Authority is charged with providing housing to low-income residents. The authority is currently assessing two options, each of which would provide homes for 100 families....
-
Alpha and Beta Companies can borrow for a five-year term at the following rates: Alpha Beta Moody's credit rating Aa Baa Fixed-rate borrowing cost 10.5% 12.0% Floating-rate borrowing cost LIBOR...
-
Example (1): Mostafa Company is preparing budgets for the quarter ending March 31, 2021. Budgeted sales for the next 4 months are as follows: 1 100 units 2 300 units 3 200 units Additional...
-
In a certain city, sports bikes are being targeted by thieves. Assume that the probability of a sports bike being stolen is 0.09 while the probability is only 0.5 for a regular bike. Taking, as an...
-
Prove that \(P(A \mid B)=P(A)\) implies that \(P(B \mid A)=\) \(P(B)\) provided that \(P(A) eq 0\) and \(P(B) eq 0\).
-
Select a problem with which you have been involved, and use the Ishikawa/fishbone diagram to structure the causes of the problem. Indicate what you feel to be the biggest causal factor.
-
Develop a WBS for an organisation with 12 employees about to undergo an office move to a greenfield site. Be sure to identify the deliverables and the organisational units (people) responsible for...
-
Was the last Olympic and Paralympic Games a success? Carry out a search of the news of the time and the relevant websites to identify the characteristics of the project management that led to the...
-
Elliot's dad bought a new car for $31,000 in 2012. Elliot read that a new loses about 13% of its value each year. What is the multiplier for this situatin 7-61.
-
Why can wastewater treatment requirements in Hawaii be less stringent than those in most locations on the U.S. mainland?
-
What are the typical design elements of a service blueprint?
-
What are the approaches firms can take to innovate, enhance, and create new services?
-
What are the six key decisions managers need to make when designing an effective pricing schedule?
-
Using the results of Problem 2.6, determine the invariants \(U_{i}\) and \(V_{i}\) for the AS/3501 lamina, where \(i=1,2,3,4\). Problem 2.6 Find all components of the stiffness and compliance...
-
Show how the Mohr's circles in Figure 2.17 can be used to interpret the transformed lamina stiffness \(\bar{Q}_{12}\). FIGURE 2.17 40 'n Q11 In- n> Q11 20 -U-
-
Using the results of Problem 2.6 or Problem 2.16, compare the transformed lamina stiffnesses for AS/3501 carbon/epoxy plies oriented at \(+45^{\circ}\) and \(-45^{\circ}\). Problem 2.6 Using the...
Study smarter with the SolutionInn App