Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please just provide the 4 answers that go in the blanks Enter Your Name Here BASE DATA: Foundation Data for Solving questions 1, 2 and
please just provide the 4 answers that go in the blanks Enter Your Name Here BASE DATA: Foundation Data for Solving questions 1, 2 and 3: Budgeted Direct Materials Cost Per UNIT 15.00 10.00 Budgeted Direct Manufacturing Labor Per UNIT Budgeted Manufacturing Overhead Per UNIT 5.00 IN ADDITION TO ABOVE USE THE FOLLOWING: This is Next Year's Budgeted Data for XYZ Budgeted Sales Price Per UNIT 20.00 Budgeted Sales - UNITS 15,000 Units Target Ending Finished Goods Inventory in UNITS 2,500 Units Target Beginning Finished Goods Inventory in UNITS 1,850 Units Target Ending Direct Materials Inventory in UNITS 8,500 Units Target Beginning Direct Materials Inventory in UNITS 6,500 Units Note: It takes one unit of direct materials to make one production unit. WITH THE ABOVE DATA SOLVE THE FOLLOWING QUESTIONS REGARDING YOUR PRODUCT 1) How many units should be produced next year? Record your answer, using excel formulas, here WITH THE ABOVE DATA SOLVE THE FOLLOWING QUESTIONS REGARDING YOUR PRODUCT 1) How many units should be produced next year? Record your answer, using excel formulas, here 2) What is the dollar amount budgeted for direct material purchased for next year? Record your answer, using excel formulas, here I 3) What is the Budgeted Revenues for next year Record your answer, using excel formulas, here USE ONLY THE FOLLOWING INFORMATION TO ANSWER THIS QUESTION. DO NOT USE ANY INFORMATION FROM ABOVE Gamble Company has the following sales budget for the last six months January 10,000 February 12,000 May March 4,000 April 7.500 15,000 2,500 June 50% Historically, the cash collection of sales has been as follows: The % of sales collected in the month of sale is The % of sales collected in the month following the sale is The % of sales collected in the second month following the sale is The % of sales that are uncollectible 30% 15% 5% 4) What are the budgeted Cash collections for the month of May? Record your answer, using excel formulas, here
please just provide the 4 answers that go in the blanks
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started