17 Jun How does a job order cost sheet help managers make decisions?
250 wors
Task 2: Using the attached Excel template, complete and upload PR 2-3A and answer the following question:
- How does a job order cost sheet help managers make decisions?
Pr. 16(2)-3A
| Problem 16(2)-3A | |||||||||||||||||||||||||||||||
| Name: | 0 | ||||||||||||||||||||||||||||||
| Section: | # N-box Incorrects due to blanks COUNTIF(B15:AT24," ") | ||||||||||||||||||||||||||||||
| 30 | |||||||||||||||||||||||||||||||
| Score: | 0% | # N-box +B-box corrects COUNTIF(B15:AT24," ") | |||||||||||||||||||||||||||||
| 0 | |||||||||||||||||||||||||||||||
| Key Code: | [Key code here] | Total SUM(AD13:AD15) | |||||||||||||||||||||||||||||
| Instructions | 30 | ||||||||||||||||||||||||||||||
| Answers are entered in the cells with gray backgrounds. | Percentage =(AD16-AD13-AD14)/AD16 | ||||||||||||||||||||||||||||||
| Cells with non-gray backgrounds are protected and cannot be edited. | 0% | ||||||||||||||||||||||||||||||
| An asterisk (*) will appear to the right of an incorrect entry. The essay answer will not be graded. | Notes: | ||||||||||||||||||||||||||||||
| If number-entry box is blank (this would be an incorrect answer for N-boxes), error check returns two spaces, " " | |||||||||||||||||||||||||||||||
| If number-entry or blank-entry box is incorrect, returns "*" | |||||||||||||||||||||||||||||||
| 1. and 2. | JOB ORDER COST SHEET | If number-entry or blank-entry box is correct, returns single space, " " | |||||||||||||||||||||||||||||
| Use data verification to set data entry to whole number >= 0, and use drop-downs for lables and names, so that students can't enter a space in a box and have it counted as correct. | |||||||||||||||||||||||||||||||
| Customer | Jackson Consulting | Date | October 1 | Conditional formatting might be used but wasn't here, to hide some of the error check return symbols. If A1 = "~*", then font = red, if something else, then font = background color. | |||||||||||||||||||||||||||
| Address | 220 Apple Lane | Date Wanted | October 10 | ||||||||||||||||||||||||||||
| Cupertino, CA | Date Completed | October 10 | |||||||||||||||||||||||||||||
| Item | carpet and installation | Job No. | 563 | ||||||||||||||||||||||||||||
| ESTIMATE | |||||||||||||||||||||||||||||||
| Direct Materials | Direct Labor | Summary | |||||||||||||||||||||||||||||
| Amount | Amount | Amount | |||||||||||||||||||||||||||||
| meters at | hours at | Direct materials | |||||||||||||||||||||||||||||
| Direct labor | |||||||||||||||||||||||||||||||
| Factory overhead | |||||||||||||||||||||||||||||||
| Total | Total | Total | |||||||||||||||||||||||||||||
| ACTUAL | |||||||||||||||||||||||||||||||
| Direct Materials | Direct Labor | Summary | |||||||||||||||||||||||||||||
| Mat. Req. No. | Description | Amount | Time Ticket No. | Description | Amount | Item | Amount | ||||||||||||||||||||||||
| 112 | meters | H10 | hours | Direct materials | |||||||||||||||||||||||||||
| at | at | Direct labor | |||||||||||||||||||||||||||||
| 114 | meters | H11 | hours | Factory overhead | |||||||||||||||||||||||||||
| at | at | ||||||||||||||||||||||||||||||
| Total | Total | Total | |||||||||||||||||||||||||||||
| Comments: | |||||||||||||||||||||||||||||||
| [Key essay answer here] | |||||||||||||||||||||||||||||||
Sol
| Problem 16(2)-3A | ||||||||||||||||||||||
| Name: | Solution | |||||||||||||||||||||
| Section: | ||||||||||||||||||||||
| Score: | ON | |||||||||||||||||||||
| Instructions | ||||||||||||||||||||||
| Answers are entered in the cells with gray backgrounds. | ||||||||||||||||||||||
| Cells with non-gray backgrounds are protected and cannot be edited. | ||||||||||||||||||||||
| An asterisk (*) will appear to the right of an incorrect entry. The essay answer will not be graded. | ||||||||||||||||||||||
| 1. and 2. | JOB ORDER COST SHEET | |||||||||||||||||||||
| Customer | Jackson Consulting | Date | October 1 | |||||||||||||||||||
| Address | 220 Apple Lane | Date Wanted | October 10 | |||||||||||||||||||
| Cupertino, CA | Date Completed | October 10 | ||||||||||||||||||||
| Item | carpet and installation | Job No. | 563 | |||||||||||||||||||
| ESTIMATE | ||||||||||||||||||||||
| Direct Materials | Direct Labor | Summary | ||||||||||||||||||||
| Amount | Amount | Amount | ||||||||||||||||||||
| 200 | meters at | $35 | 7,000.00 | 16 | hours at | $20 | 320.00 | Direct materials | 7,000.00 | |||||||||||||
| Direct labor | 320.00 | |||||||||||||||||||||
| Factory overhead | 240.00 | |||||||||||||||||||||
| Total | 7,000.00 | Total | 320.00 | Total | 7,560.00 | |||||||||||||||||
| ACTUAL | ||||||||||||||||||||||
| Direct Materials | Direct Labor | Summary | ||||||||||||||||||||
| Mat. Req. No. | Description | Amount | Time Ticket No. | Description | Amount | Item | Amount | |||||||||||||||
| 112 | 140 | meters | H10 | 10 | hours | Direct materials | 7,280.00 | |||||||||||||||
| at | $35 | 4,900.00 | at | $20 | 200.00 | Direct labor | 400.00 | |||||||||||||||
| 114 | 68 | meters | H11 | 10 | hours | Factory overhead | 300.00 | |||||||||||||||
| at | $35 | 2,380.00 | at | $20 | 200.00 | |||||||||||||||||
| Total | 7,280.00 | Total | 400.00 | Total | 7,980.00 | |||||||||||||||||
| Comments: | ||||||||||||||||||||||
| The direct materials cost exceeded the estimate by $280 because 8 meters of materials were spoiled. The direct labor cost exceeded the estimate by $80 because an additional 4 hours of labor were used by an inexperienced employee. The factory overhead cost exceeded the estimate because an additional $60 of factory overhead was allocated because of the increase in direct labor. | ||||||||||||||||||||||
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteEdu. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
Do you need help with this question?
Get assignment help from WriteEdu.com Paper Writing Website and forget about your problems.
WriteEdu provides custom & cheap essay writing 100% original, plagiarism free essays, assignments & dissertations.
With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Chat with us today! We are always waiting to answer all your questions.