You will create this assignment following the Assignment Detail instructions below. This assignment will be submitted in the Unit 4 – Submission Assignment 1 lesson in intellipath.
Review the tutorial titled How to Submit the Intellipath Submission Assignment.
Please submit your work to this week’s Intellipath Unit Submission lesson. Click the Upload button within the submission lesson to access the submission area. Click the Select File button to upload your document, and then click “OK” to finish.
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.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more