Chicago Furniture Company produces combination desk and chair sets for the elementary schools in the Midwest. As the second quarter is progressing it is important for the controller to complete a budget for the third quarter. The sales department manager has provided the following forecast.
July8,000 desk combosAugust8,700 desk combosSeptember
7,600 desk combos
October8,700 desk combosNovember8,800 desk combos
In order to ensure Just-in-Time (JIT) deliveries are maintained in accordance with the needs of the schools Chicago Furniture Company has a standing policy that the inventory at the end of each month must be equal to 40% of the following month’s forecasted sales. On July 1st there will be 3,200 desk combos in inventory.
The building of each desk combo requires 12 board feet of pine planks which cost $0.70 per foot. In order to maintain proper inventory for building the desk combos the department must have 30% of the next month’s production requirements.
Using Microsoft Excel, create a spreadsheet for the production and material purchases budget for the 3rd Quarter.
For assistance with your assignment, please use your text, Web resources, and all course materials.
Your assignment will be graded in accordance with the following criteria. Click here to view the grading rubric.
If you are planning to repurpose an assignment or submit one you have used before, please let your instructor know. If an instructor is not made aware of work being repurposed or reused, he or she will treat the assignment as a plagiarized task and reserves the right to post an F grade and submit a task for review to administration until proof of originality is provided. Click here for more information.The following are some tips if you have problems submitting your assignment:
Resave in the proper format per the Assignment Detail instructions, and resubmit.
Submit with a different Web browser.
Submit from a different computer.
Call Technical Support at 877-221-5800, Menu Option 2. They are open 24/7.
If you are still having difficulties after trying steps 1–4, please contact your course instructor.
Make sure you submit this assignment by the listed due date. Late deductions will apply for this assignment as follows:
Assignments submitted within 7 calendar days after the stated due date: 10% penalty of total assignment points.
Assignments submitted 8–14 calendar days after the stated due date: 20% penalty of total assignment points.
Assignments submitted 15–21 calendar days after the stated due date: 30% penalty of total assignment points.
Assignments submitted 22–28 calendar days after the stated due date: 40% penalty of total assignment points.
No assignments, including late assignments, will be accepted after the end of the course unless an approved Incomplete has been granted
The post the Assignment appeared first on Homework Aider.
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."
"Order a custom Paper on Similar Assignment at essayfount.com! No Plagiarism! Enjoy 20% Discount!"
